Multiple Slicer Dropdown

[realiza]

Hi,

I have 3 slicers (region, province, town) using 1 table (having region, province, town), another slicer for issues (another table), another slicer for potentials (another table)

By default, all data in the slicer will be shown.

If the region is selected the province and town will be filtered.

But the issues and potentials does not follow, it show select all but no data/list.  

I already have the relationship of table 1 to issues and potential tables. 

Anf if select an issue or potentail, the region/province/town will ont be filtered

Realiza

[v-juanli-msft]

Hi @realiza 

Create relationships as below

You can download my pbix to play with.

As tested, in this way, i can filter among these slicers successfully.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[realiza]

Hi Maggie, 

the complete relationship is this 

reg_name is region, prov_name is province

Also, if I try to filter the province, region and town will follow but issues and potential will not. 

The same if I select town. 

Regards, 

Realiza

[v-juanli-msft · Accepted solution]

Hi @realiza 

As tested, when change relationships from single to both,

i can slicer the items successfully.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.