Forum Discussion
Graph's changing as you select different locations on Map (ESRI)
The Pop-up that comes when you try to join the tables is because both the tables have multiple entries of same company name in the column.
But Power BI expects atleast one of the column to be unique while joining. i.e. There is no direct Many to Many relationship in Power BI
To solve this introduce a Bridge table between the tables that you want to join. The Screenshot for the same is given below
Relationship between tables through a bridge table
In the above case, both Table 1 and Table 2 have multiple occurences of same date in the Date Column and hence cannot be joined directly. So a new table Table 1(2) is introduced between them.
Table 1(2) is a bridge table that has only the unique dates from Table 1 and the tables are joined using it.
Note: The Cross filtering direction (single/ both) should be changed as per your need
Thank you so much!!!
i will give that a try now!
- v-jiascu-msft8 years ago
Microsoft Employee
Hi brettnelson,
Did you solve it? Can you share the answer or mark the proper answer as a solution please?
Best Regards,
Dale