Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago
Solved

Filter Slicer values based on another slicer

This is the Situation:   So I have 1 small slicer with 2 company options. And 1 slicer with 7 region option. 2 of these regio's should be hidden anyway.   However the remaining 5 should b...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    rpinxt ,

     

    can you try something for me, drag a measure that is done on the main data atble and put it in the filter pane of the company silcer visual and set to to is not blank.

     

    and then try to filter commercial region

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago

Nice! I think I see what you did there.

So I placed volume on the slicer.

 

Meaning that only countries with volume will be in scope and because country is linked to the region only these regions will show 😄

Smart. Thanks.

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

rpinxt ,

 

hahaha yeah I like this trick and make life easier than messing up the modeling.