Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm pretty new to Power BI, but I have been asked by a client to investigate the use of the 3rd party "HierarchySlicer" visualization.
That particular visualization has a built-in data record limit of 4000 (by using the dataReductionAlgorithm code).
I can tweak the number specified in the code to be a larger number, but no matter how high I set it, I am only ever getting back a maximum of 30,000 records.
The client has more than 30,000 records in the data set they wish to show in the slicer.
I also followed a simple tutorial to create a quick slicer visulization of my own, but I'm hitting the exact same 30,000 row limitation.
"dataViewMappings": [ { "categorical": { "categories": { "for": { "in": "fields" }, "dataReductionAlgorithm": { "top": { "count": 500000 } } } } } ],
Is this something that can be worked around, or is there an alternative way of getting all the required data to show?
Does the same limitation apply if/when the dashboard is published?
Many thanks, and apologies if this is duplicating queries...
Solved! Go to Solution.
That's currently a hard limit for the data reduction algorithm.
30,000 options in one slicer is a lot. Would the client be open to using a combination of Filters and maybe training them on the Basic or Advanced filter criteria?
You may try dataReductionAlgorithm "window" instead of "top".
That's currently a hard limit for the data reduction algorithm.
30,000 options in one slicer is a lot. Would the client be open to using a combination of Filters and maybe training them on the Basic or Advanced filter criteria?
Thanks,
Yes - the client will implement some form of pre-filtering before using the slicer visual.
Thanks for confirmation of the 30,000 limit.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |