Forum Discussion
Multiple Slicer Dropdown
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
Hi realiza
As tested, when change relationships from single to both,
i can slicer the items successfully.
Best Regards
MaggieCommunity 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.
3 Replies
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
MaggieCommunity 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.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
Hi realiza
As tested, when change relationships from single to both,
i can slicer the items successfully.
Best Regards
MaggieCommunity 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.
