Forum Discussion
Slicer issue
Hi All
I create 2 slicers, 1 for Category and another for Sub Category. So, in 1st step, I will select “Fruit” from Category & “F1” from Sub -Category. Now, If, I change my value in Category Slicer from “Fruit” to “Vegetable”, I want automatically, 2nd slicer should select 1st value of Vegetable i.e. V1 or atleast unselect the previous value i.e. "F1"
Category | Sub-Category |
Fruit | F1 |
Fruit | F2 |
Fruit | F3 |
Vegetable | V1 |
Vegetable | V2 |
Vegetable | V3 |
Kind Regards
Ashwani
8 Replies
- Yeah, unfortunately it doesn't work that way in my experience.
Anonymous this is how slicer works and its default behavior. There is an idea post on this, please vote that if you think this behavior need a change.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hi Anonymous ,
Have you tried to make an hierarchly slicer insteaf of 2 slicers?
If you place both columns on the slicer it will give an hierarchy and then the selection of the Category will select the sub and clear the previous value.
MFelix - Thanks for your response. Yes, I checked hierarchy slicer as well but I have long list like 70 value for 1st column and 35 for 2nd value. So, it is not looking good on hierarcy slicer.
Kind Regards
Ashwani
Hi Anonymous ,
If you want to achieve at least unselect the previous value i.e. "F1" when changing to “Vegetable”, you can try this way but I think it doesn't make much sense:
Using 'Edit interaction' and set two slicers status to 'None' and you will get the result like this:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
v-yingjl - Thanks for your response. If I'll stop the interaction then there is no meaning to use 2 different slicers as both will work independently.
Kind Regards
Ashwani
