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
Create a locations table, with each location being unique and having your location code. Link all of those tables to this location table. Then on your bubble chart, use that location table as the filter.
That 'location's table' is the "Main Companies" table displayed on the relational image and when I attempt what you recommend I get the following:
Am I missing something? All tables are linked via location to that Main Companies table.
Check your link between 'Main Companies' and the weekly data. It needs to be a solid line with a 1 to many relationship. It might even be worth deleting the relationship and relinking it.
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.
