Hide One slicer when no option selected

[Anonymous]

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

[Icey · Accepted solution]

Hi @Anonymous ,

You can refer to this blog: Show or Hide a Power BI Visual Based on Selection.

Best Regards,
Icey

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

[Gordonlilj]

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]

This is hiding the other options in slicer1

[Icey]

Hi @Anonymous ,

Please give me more details such as some screenshots.

Best Regards,

Icey 

[Anonymous]

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

[Gordonlilj]

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

[Anonymous]

This is hiding the other options in slicer 1, when i select a option