Forum Discussion
Link Two Tables for visual link
Lo again,
I am using two tables for a variety of display visuals but I cannot link one table directly to another due to no single value in either of the two referenced tables (WklyRawData & Goals). I am sure I am also not setting this up as efficiently as possible as I am having to create a numbe of tables from my raw data to get these to work.
I would love to have the bubble chart also act like a slicer for all visuals on this first tab, but since the relationship isn't there the bubble only impacts four of the various visuals.
Any tricks/tips on what I can do to remedy this?
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
8 Replies
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.
