Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mrothschild
Continued Contributor
Continued Contributor

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

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!

 

LRF.PNG

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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:

MFelix_0-1617884850866.png

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

MFelix_1-1617884930147.png

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

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

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:

MFelix_0-1617884850866.png

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

MFelix_1-1617884930147.png

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

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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
Continued Contributor
Continued Contributor

@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

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 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.