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...
Need Help
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 slicer 1, when i select a option