Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Remove slicer selection when no data


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

 

 

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

     

6 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Ritaf1983
        Super User
        2 years ago

        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.