Forum Discussion
Clearing second slicer when changing the first slicer
Hi,
Now I have 2 slicers on my report.
* Slicer 1 : select the headcategory
* Slicer 2 : select the subcategory's from the selected headcategory
When I change the first slicers, my second slicer keeps the selected subcategory's from my previous selected headcategory.
Is it possible to clear my second slicer when changing the first one?
kind regards,
Davina
6 Replies
- Pragati11
Super User
Hi Anonymous ,
Two ways of doing this:
- Clear your Sub-category slicer before selecting anything in Head category slicer.
- Create a bookmark to clear selections from Sub-category slicer: https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story
Thanks,
Pragati
- amitchandak
Anonymous , You can do that using bookmark.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Explore if Hierarchy slicer works better - https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchical_slicer
HI Anonymous ,
Check this video from Reza Rad.
https://www.youtube.com/watch?v=cyOquvfhzNM
Regards,
Harsh Nathani
v-lionel-msftCommunity Support
Hi Anonymous ,
Or do like this.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-lionel-msft
Hi Anonymous ,
Has your problem been solved?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lionel-msftNo, my question did not answer like I wanted. Interaction works but do not deselect my previous selection in my second slicer.
At the moment I fixed it with a clear all button.
