Forum Discussion
Solution SageFilter Slicer values based on another slicer
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
Solution SageIdrissshatila , there is a relation between the tables yes. But no direct relation between these 2 fields.
If I click 3200 all regions show and if I click 2104 also all regions will show.
The table that hold company also holds sales district.
The table that has region holds country.
Both tables are connected via Sales District < - > Country
Super Userrpinxt ,
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
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