Slicer - creating a discrete, i.e., non-continuous, slider with between selection

[mrothschild]

Hi,

I'm trying to create a slicer that uses the slider bar, but so that the slider jumps in the increments of the data the slicer is referencing.

Shown below are two different versions of the same slicer, one with a [list] and the other with a [between] including the slider.  I'd like the slider to move in increments of 0.125%.  I can do this with the slider if I select [single value] after creating a parameter and creating a relationship between the new parameter and the original data, but I'd really prefer the slicer to offer a range rather than a single value.  

Thanks in advance!

[MFelix · Accepted solution]

Hi @mrothschild ,

To my knowledge you cannot setup the values like this what I did was the following, and I'm assuming you have the values that you use for a slicer in a single table:

• Created an ID column for each value:

• Create to slicer with values between one for each column:

• Turn on interaction between both slicers
• Turn Off the slider in the % slicer
• Placed the input on top of the other slicer
• Group both slicers and now has you can see both of them move has one:

Check PBIX file attach.

[gandalf1969]

This is a BRILLIANT solution(!) to such a very basic shortcoming in PowerBI (add to the list) that they need to go back and address.  Thank you for this - I am going to revisit a few recent projects and implement this immediately!  <insert free beer here>

[mrothschild]

@MFelix Thanks so much!  

The "interaction" component left me a bit confused so for those in a similar position:

1) Create two different slicers, one based on index the other based on desired output

2) Select the index slicer

3) On the menu bar, go to /Format/Edit Interactions

4) On the desired output slicer, in the upper right hand corner, click on the "filter" icon

[MFelix]

Hi @mrothschild,

Sorry for the lack of information but I assumed your already were used to it.

Also on another note grouping and the order of the slicers within the group is also important because of the way visualizations will be showned