Forum Discussion
Link Two Tables for visual link
Hi Miskondukt,
From your original post, I notice that you have very complex and unclear relationships for your modes.
Normally, we should have one fact table(Sales) with multiple dimensions tables(i.e. Date, Product, Location), then build up relationships around the fact table with multiple dimensions tables, which is often called a Star schema configuration (a central table with several Lookup tables). In this way, it will be much easier to build up visuals that can cross filter each other on the report. :smileyhappy:
For more details about how to create and manage relationships in Power BI Desktop, you can refer to this article.
Regards
Hi Miskondukt,
From your original post, I notice that you have very complex and unclear relationships for your modes.
Normally, we should have one fact table(Sales) with multiple dimensions tables(i.e. Date, Product, Location), then build up relationships around the fact table with multiple dimensions tables, which is often called a Star schema configuration (a central table with several Lookup tables). In this way, it will be much easier to build up visuals that can cross filter each other on the report. :smileyhappy:
For more details about how to create and manage relationships in Power BI Desktop, you can refer to this article.
Regards
Got it! It was editing the cross direction filter to "Both" from single.