Forum Discussion
Number Range as Slicer
Hi, Anonymous
Slicer with Between option will display continuous value. You can try to create a What-if parameter.
1 Create a What-if parameter
2 Crete relationship for parameter table and your table
3 Display the Slicer with Single Value
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
I don't think that is possible. The slider only allows continuous values, not discrete jumps in value.
Regards
Phil
The OP is anonymous now but I have a workaround for this based on another solution here:
https://community.fabric.microsoft.com/t5/Desktop/Between-slicer-for-categorical-values/m-p/2677323/highlight/true#M937895.
You can have your parameter set up with any increment. Then add a calculated column to rank your parameter range with RANKX, and use the rank column in a between slicer instead of the parameter itself.
Then you can cheat visually as well by adding two cards that overlap the value selections in the slicer, and two measures that calculate max value and min value of the parameter. Then you will have a continous slicer under the hood (based on the rank) but it will display and filter the distinct parameter values based on the increment you set.
You can see my setup here with a parameter from -20 to 20 with increment of 5
Note that it might bug a bit visually in pbi desktop, but if you turn on maintain layer order for each element it will work seamlessly once published.