How to hide slicer2 if slicer1 is not selected

[amaaiia]

Hi,

I have 2 slicers, I want to show slicer2 if slicer1 is filtered. I already have a measure created for this, and I've tried to implement this functionality by using shapes, setting color to white when slicer1 is not filtered, and to transparent when it is.

Visually, it works, however, as shape is in front of slicer2, I cannot filter later, because when I click on it, I'm clicking the shape, not the slicer.

Any ideas on how to solve this?

This is what i have:

Slicer 1 not filtered:

Slicer 1 filtered:

[V-yubandi-msft · Accepted solution]

Hi @amaaiia ,

Thank you for reaching out to the Microsoft Fabric Community. @ibarrau Thank for your response.

if nothing is selected from slicer1 then no background and no values shown in slicer2(above pic)

if anything is selected from slicer1 then background and values shown in slicer2(above pic)

Measure :

Slicer = if(ISFILTERED(T1[c1]),1,0)

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[ibarrau]

Hi. I don't think there is a default functionallity for this, but you can build the effect with a measure. Check the following picture out:

I have created a measure that checks if the category slicer ISFILTERED. Then return 0 (notfiltered) and 1 (filtered). Pick the second slicer and add the measure at the filter pane visual level filtering the visual when the measure IS 1. That will keep the measure blank unless you filter the first slicer.

I hope that helps,