Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I'm coming from Amazon Quicksight and have been working with Power BI for less than two months only.
One requirement we have currently is to provide a slicer for collecting user input (whole number), which will then be used for calculating mesaures.
I created a What-if parameter, with range between 0-100,000,000 and increment of 1, and using a slicer out of the same, in single value format, without the slider.
Issue is, for small values like 1,000 once I enter the value and hit enter (or even click outside the slicer), the slicer reverts to 0. And when I enter bigger values, it readjusts to some value close to the inut but less than that (eg: If I input 50000, it is changed to 49950).
When I reduced the range to something like 10,000 it seems the slicer was accepting more values. But the problem is, the requirement needs the range to be this high.
Anybody know why this is happening? And any solution for my requirement?
Thank you!
Solved! Go to Solution.
That's how slicers work - you can have a maximum of 1000 discrete values. Your "range between 0-100,000,000 and increment of 1," is far, far outside these limits.
Use the filter pane instead and teach your users how to use it.
Thanks. I have made adjustments with the range and increment so that the available 1002 values in the slicer fits the need of business users
That's how slicers work - you can have a maximum of 1000 discrete values. Your "range between 0-100,000,000 and increment of 1," is far, far outside these limits.
Use the filter pane instead and teach your users how to use it.