Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |