The DistinctValuesLimit property is available in our R1 2018 Release.
Hi Paulo, There is another item in the portal regarding the filter TextBox, please vote for it on the the following link: https://feedback.telerik.com/Project/143/Feedback/Details/201209-pivotgrid-filtering-textbox-for-distinct-values As for this feature request we have added DistinctValuesLimit property to the Adomd and Xmla providers. It is already live with the latest internal build - please give it a try. Kalin
I would like the suggest add filter textbox similar the excel. When there are many options is more easy use the text to filter the values.
the WPF control code that is being used limits to top 100: SELECT {TOPCOUNT(AddCalculatedMembers({[Products].[SKU].Children}), 1000)} DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS FROM [Account Planning] I have changed this in the source code to test, but getting the controls building was impossible.
There is a KB solution to same problem in ASP.NET Ajax, https://www.telerik.com/support/kb/aspnet-ajax/pivotgrid/details/filter-list-missing-values-with-large-amount-of-data