Forum Discussion
Solved
Slicer Selection based on another Slicer Selection
I have a requirement to filter a slicer using another slicer. I have two slicers, Company Code and Currency Selection as shown below. The requirement is when I select one company the Currency Select...
Thank you very much I will give it a go and let you know.
I would do it like that :
nb_selected =
IF( Sheet1[Currency] = "Local Curr"
, IF(ISFILTERED(Sheet1[CoCd]), COUNTROWS(VALUES(Sheet1[CoCd])),1)
, 1
)
The goal is to filter the slicer with nb_selected = 1 only for currency Local.
Thanks Thomas