Forum Discussion

EvH's avatar
EvH
Frequent Visitor
3 years ago
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...
Need Help
  • EvH's avatar
    EvH
    3 years ago

    Thank you very much I will give it a go and let you know.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

EvH , for that you can remove all values from the slicer

 

create a measure like

 

if( calculate(distinctcount(Table[Company]), allselected()) >2, 0, 1)

 

Use a visual level filter and check for value =1