Creating blank rows for data without a match

[crobson29]

This is a very weird issue, but I have a table visual that pulls from 2 different data tables joined with a many-to-many relationship.  I know that this isn't ideal, but it is a necessary evil unfortunately.  Anyway, the visual is showing the first column, but has blanks for the rest if there is not a match on one side of the relationship.

When I remove the columns from the second data table, all of the data populates properly. 

I blocked out some information, but it is there.

I expect to have blank values for the columns from the second data table, but why is it removing information that exists in the first?  I have show items with no data turned on, and I've tried changing the filter direction, the same thing happens no matter what, I currently have it filtering both ways.  

[PabloVallejo12 · Accepted solution]

Maybe you can create a new table with the match of both tables with the summarize function, and use this new table in your visualization 

[crobson29]

This is a weird one, as Power BI is known to be.  I had some success with the bridge table idea, but it created some problems with the links that I had built, which is a totally separate problem.  I decided to go back and essentially start over.  Initially, I tried rebuilding the relationship, and then rebuilding the table.  What ended up working was deleting the table, deleting the relationship, rebuilding the relationship, then rebuilding the table.  Any order other than this resulted in the same problem.

[v-shex-msft · Accepted solution]

Hi @crobson29,

Perhaps you can try to create a table with unique values as bridge to link two side tables, they should help you mapping table relationship more accurately.

Joining Many to Many with a Bridge in Power BI 

Regards,

Xiaoxin Sheng

[PabloVallejo12 · Accepted solution]

Maybe you can create a new table with the match of both tables with the summarize function, and use this new table in your visualization