Dimension tables not filtering each other

[unnijoy]

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.

[vojtechsima · Accepted 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

[unnijoy]

Hi @vojtechsima ,

Thanks a lot for the clarification and the link. Good day 🙂

[vojtechsima]

 @unnijoy 
You're welcome, leave a message here if the solution will work for you.