Filter/slicer clickable interaction

[Anonymous]

Hi,

In our report we have 3 slicers/filters, but we want to do advanced interaction between those.

* If we check a item in slicer 1, then show only the related items in slicer 2 & 3 (this can you do with edit interaction)

* Slicer 3 should only be clickable when slicer 1 & 2 has checked items.

Can you help with my last bulletpoint?

Thanks,

Davina

[Greg_Deckler · Accepted solution]

@Anonymous Maybe a visual level filter on a measure like:

Measure = IF(ISFILTERED('Slicer1'[Value]) && ISFILTERED('Slicer2'[Value]),1,0)

Filter on 1