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 All,
I have a fact table and two dimension table. Dim Table 1 got the name of country and it is mapped to Fact table "Coutry". (Many to One). Dim Table 2 got the managers name. and is mapped to Fact Table "Manager name". (Many to One). Now i create two slicers. One for Country and other for manager name. The issue is that when i select a manager form Manager slicer it is showing all country in Country Slicer. Why is it not filtering the Country slicer based on the selected manager.
Now it is showing all country insted of giving only those country where that manager for team members.
Solved! Go to Solution.
Hello, @unnijoy
That's kinda the correct behavior, since Dimensions by design are usually OneToMany with a single cross filter. So they only filter the Fact table, not other dimensions.
If you want them to filter each other check this link:
https://radacad.com/one-dimension-filters-another-dimension-in-power-bi
Hello, @unnijoy
That's kinda the correct behavior, since Dimensions by design are usually OneToMany with a single cross filter. So they only filter the Fact table, not other dimensions.
If you want them to filter each other check this link:
https://radacad.com/one-dimension-filters-another-dimension-in-power-bi
@unnijoy
You're welcome, leave a message here if the solution will work for you.
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 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |