Forum Discussion

RingoMoon's avatar
RingoMoon
Frequent Visitor
2 years ago
Solved

Dynamic slicer slider based on another slicer

Suppose I have TableA

PersonValueTag
A1Sales
B876Customers
C1Customers
D113444Sales
E2Customers

 

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

  • RingoMoon's avatar
    RingoMoon
    Frequent 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.