Deselect option based on other slicer

[RWRW]

Hi,

I have this table

In my report I added 2 slicers, both sigle selection. Equipment slicer interact with Year Slicer but not opposite So when I choose the equipment is loading in the other slicer the year belongs to this equipment.

When I choose the Equipment 2, the year slicer still with the previous option selected and the year which belongs to Equipment 2 2022.

the goal, everytime the user click in Equipment the Year slicer will display no option selected until the user clicked.

[Ritaf1983 · Accepted solution]

Hi @RWRW 

Due to the single-select nature of slicers, where one option is always "selected," the functionality you mentioned is unfortunately not available.

There is an idea about this issue, please vote for it here :

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e6d0b76e-f341-48b0-8c83-c0f3be630162

Alternative Solutions:

1. Bookmarks: You can create the desired functionality using bookmarks, but this approach is less recommended.

2. Hierarchical Slicer: Instead of using two separate slicers, you can employ a single hierarchical slicer. This will allow you to filter the data based on multiple levels of the hierarchy

   

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