Forum Discussion
Label category with no link in second table
I have two tables
Table A
Table B
I connect table A to B using ID. However, there are IDs from A that don't have a match in B. The result is:
The highligted ones are IDs that dont have a match in B.
Goal: Label the first row as unknown
Problem: that blank segment (first row) is really not existing in table B.
Is there a way to put a label on it?
4 Replies
- Idrissshatila
Super User
Hello,
its better to fill the data, what you could do is make table B from table A, by copying Table A and removing the Duplicates so you could have the One side (Dimension Table) and then you could use it and vidualise as per this new table.
If I answered your question, please mark my post as solution, Appreciate your Kudos!
- Idrissshatila
what I meant is that you get the table with all the IDs and make it your dimension table by removing the duplicates and you connect it with the fact table..
HI Anonymous,
Perhaps you can refer to the following blog to extract and create a bridge table from two table records mapping. Then you can use the bridge table value as category on your chart:
How to Join Many to Many with a Bridge Table in Power BI (seerinteractive.com)
Regards,
Xiaoxin Sheng
