Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter/slicer clickable interaction

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

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

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

     

    Filter on 1

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous Maybe a visual level filter on a measure like:

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

     

    Filter on 1