Label category with no link in second table

[Anonymous]

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?

[v-shex-msft]

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

[Idrissshatila]

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!

Follow me on Linkedin

[Anonymous]

Hi,

I cannot visualize it. Can you give example or sample screenshots? 

[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..