Number Range as Slicer

[Anonymous]

Hi Folks,

I have field numeric field name -"Agreement Time Left" which has values 15,30,45,60,75,90. I want to use these numeric values as filters(slicers) and instead of selecting an individual value, I want it to be a slicer range type. On changing the filter from list values to between values, I get all numbers from 1-100 but instead, I need only 15,30,45,60.. on my slicer.

If the default visual in Power BI does not allow slider at discreet values, do we have any visual in-app store with this functionality

Please refer to my screenshots below for reference

[v-cazheng-msft · Accepted solution]

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.

[PhilipTreacy]

Hi @Anonymous 

I don't think that is possible.  The slider only allows continuous values, not discrete jumps in value.

Regards

Phil

[dk_dk]

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/...


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.