Filter Slicer values based on another slicer

[rpinxt]

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 be visible. Could leave them all in but for company 2104 some would make no sense and vice versa for company 3200.

So the proper solution would be that base on the company I choose the corresponding regions would show up in the region slicer.

Was thinking maybe something with a measure giving 0 and 1 for a region based on which company is selected.

Then use that as a filter on the region slicer (filter must be 1 to show)?

ps: Commercial region and company come from 2 separate tables.

[rpinxt]

@Idrissshatila , 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

[Idrissshatila · Accepted solution]

@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]

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]

@rpinxt ,

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

[Idrissshatila]

HEllo @rpinxt ,

there must be a relationship between commercial region and compnay so that it filters each others.