Filter dimension tables in Star schema?

[richard-powerbi]

First I had a flat table and when I filtered in the filters pane, it would also filter out the other 'dimension columns'.

Now I made it into a star schema and when I filter 1 dimension in the filters pane, it doesn't filter the other dimensions. It shows all values in that column. I understand why, but how can I achieve this?

Note: I have multiple fact tables that connect to these same dimension tables. Below is 1 of the star schemas.

[Jim_B]

Did you ever find a solution for this?  I've read much about how one can solve this if using slicers, but nothing about how to solve it when using the filter pane.  I've tried many model options and nothing seems to work.  Bi-directional ends up with circular references; I'm never working with M:M relationships and don't intend to; etc. 

[Anonymous]

Hi @richard-powerbi ,

If I understood you correctly you should get the relationships both sided.

Let me know if that's what you wanted and if it worked, if so mark as solution.

BR,

DR

[richard-powerbi]

Hi @Anonymous
I know this is a solution, but I always read you should avoid bidirectional relationships for performance and aggregation risks. This way I'll get many bidirectional relationships. Is there another solution? Or how can I check if it messes up my aggregations? I know it happens if there is more than one path to follow, but this is very hard to analyze in a big model....

[Anonymous]

I don't think so unless you make some common table that associates all the foreign keys from those all tables.

BR,

DR

[richard-powerbi]

So I'm trying to implement this now. Would I have to add the table with only the keys between the fact tables and dimension tables? Or on top of the dimension tables? Could anyone sketch this?

[richard-powerbi]

Yea that might be a better solution. I'll accept it as a solution once I've implemented it.

[v-lid-msft]

Hi @richard-powerbi ,

How about the result after you follow @Anonymous 's suggestions ?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[richard-powerbi]

I still have to implement this, when I have no other questions I'll accept it as a solution.