Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Hide One slicer when no option selected

Hi all,

I got stuck in my task. I have kept two slicers in my page. First slicer will have two options (product and city) and second slicer will have options for the above slicer(if country selected second slicer lists list of countries). if no option is selected in slicer1, the second slicer is displaying all values for country and products, whereas i want to hide second slicer when no option is selected in slicer1.

 

Hope for a sooner solution.

 

Thankyou

 

 

Need Help

7 Replies

  • Gordonlilj's avatar
    Gordonlilj
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hi,

     

    If I understand you correctly then one thing you could try would be to create a measure like this

    HideSlicer = IF(ISFILTERED(Table[Slicer1Column]),1,0)

    Then use the measure as a filter on the second slicer like below

     

    This should "hide" the second slicer when no option is selected in the first

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thankyou Gordonlilj, but this measure is not helping to hide the slicer. can you pls check in your application

      • Gordonlilj's avatar
        Gordonlilj
        Icon for Solution Sage rankSolution Sage
        6 years ago

        The measure works for its intended use. Can you be more specific?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This is hiding the other options in slicer1

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

        Please give me more details such as some screenshots.

         

        Best Regards,

        Icey