Remove slicer selection when no data

[Anonymous]

Hi Experts, I just want to ask help on how to remove the selection of slicer,  When I select January from the month filter, and then switch to the year filter, January stays selected. How can I remove the month selection when I choose a year? Any help would be appreciated.

Thanks, 

Dale

[Ritaf1983]

Hi @Anonymous 
The short answer is that if the first slicer interacts with the second, the user should remove the month's selection before changing the "main" slicer, there is no option to clear it automatically.
To suggest alternatives, it can help to see the data example and to understand what you are trying to achieve.

please share a pbix or some dummy data that keeps the raw data structure with expected results. It should help us clarify your scenario and test the coding formula.

How to Get Your Question Answered Quickly  

[Anonymous]

Hi @Ritaf1983 

Here is the sample scenario:

1. "Select 'By Month' in the Filter Slicer, and then choose 'January' in the Month Slicer."

2. When switching to "By Year," I want the month slicer to reset or REMOVE the selection since there is no data. 

The expected output should be like this: 

Here is the sample Dataset

sample_dataset.pbix 

Thanks, 

Dale

[Ritaf1983 · Accepted solution]

Hi again 🙂
There are a few alternatives that i can suggest :

1. guide the user to click on the reset slicer , like :

2. You can add button clear slicers like :

3. Move from the slicers and just create 2 pages with the wanted granularity instead + page navigator like :

*** All the options can be created with much better design there are just drafts to show the logic

pbix is attached

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

[Anonymous]

Thanks for this alternatives 😘

[Ritaf1983]

Happy to help 🙂

[Anonymous]

if there theres any other alternative , it would be helpful