Clearing second slicer when changing the first slicer

[Anonymous]

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

[v-lionel-msft]

Hi @Anonymous ,

Or do like this.

Best regards,
Lionel Chen

If 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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

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

[harshnathani]

HI @Anonymous ,

Check this video from Reza Rad.

https://www.youtube.com/watch?v=cyOquvfhzNM

Regards,

Harsh Nathani

[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

[Pragati11]

Hi @Anonymous ,

Two ways of doing this:

1. Clear your Sub-category slicer before selecting anything in Head category slicer.
2. Create a bookmark to clear selections from Sub-category slicer: https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story

Thanks,

Pragati