Forum Discussion
How can I create a relationship between these two tables?
It looks like a many-to-many, but I can't figure out how to get it done in Power BI.
- Table 1 shows which Name can service which locations.
- Table 2 shows which trades each name is able to serve.
I'm trying to link these by Name, so that I can add slicers and be able to (for example) view which trades are available in New York.
This is a simplified scenario, real data would have thousands of rows. When I attemp to link the data, I get an error saying that at least one table must have unique values.
Create a third query. Use one of your sources that has all the Names that you need and remove all other columns. Remove duplicates. Use this table to relate to each of the other tables. This is a bridge table. You will have to be somewhat careful with this as if you have information from both linked tables in the same visual it can cause problems unless you aggregate values from one of the tables. But, that is the general idea.
1 Reply
- Greg_Deckler
Community Champion
Create a third query. Use one of your sources that has all the Names that you need and remove all other columns. Remove duplicates. Use this table to relate to each of the other tables. This is a bridge table. You will have to be somewhat careful with this as if you have information from both linked tables in the same visual it can cause problems unless you aggregate values from one of the tables. But, that is the general idea.