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.
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.
Correct me if I am wrong, when you state a "fact table" then that is a table of cleaned data that would act/represent that fact table rather than the organic (exported) data?