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
Anonymous Thank you helping guide me in the right direction. I tried that option and got a few more notices from PBID.
I corrected the relationship to a solid line but cannot change it to 1 to many, says "the cardinality you selected isn't valid for this relationship." Have also tried removing all of the indirect relations and received the same response.
Try restructuring your data relationships such that your "Main Companies" table is in the middle and all other tables (where possible) link directly to it. Kind of like a star pattern. The visual interface can help make this easier too.
Some tables won't have a relationship with Main Companies directly, if they don't use the location code and thats fine. They can link where required to their intended tables.