Forum Discussion
Anonymous
5 years agoNot applicable
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_DecklerCommunity Champion
Anonymous Maybe a visual level filter on a measure like:
Measure = IF(ISFILTERED('Slicer1'[Value]) && ISFILTERED('Slicer2'[Value]),1,0)
Filter on 1