Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |