Forum Discussion
Dynamic slicer slider based on another slicer
Suppose I have TableA
| Person | Value | Tag |
| A | 1 | Sales |
| B | 876 | Customers |
| C | 1 | Customers |
| D | 113444 | Sales |
| E | 2 | Customers |
Now I'm going to create two slicers. The first slicer will contain the Tag column which will allow me to switch between Sales and Customers. The second slicer will contain the Value column which I can then turn into a slider.
By default, the maximum value of the slider would be 113444 because that's the highest number in the Values column.
I want to make the slider values dynamic based on the Tag slicer. So for example if I select Sales in the Tag slicer, then the maximum value of my slider should be 113444, but if I select Customers in the Tag slicer then the maximum value of the slider should be 876.
I've tried doing this with visual level filters but I just couldn't get it to work. Is this even possible to do in the first place?
Thanks!
Turns out I just had to edit the interaction between the two slicers. By default, interactions between slicers are disabled so I just had to enable that.
2 Replies
- amitchandak
Super User
RingoMoon , As far as I know, We can not default the value the way you wanted.
- RingoMoonFrequent Visitor
Turns out I just had to edit the interaction between the two slicers. By default, interactions between slicers are disabled so I just had to enable that.