Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
crobson29
Helper I
Helper I

Creating blank rows for data without a match

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.

crobson29_0-1718112985144.png

 

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

crobson29_1-1718113254518.png

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.  

2 ACCEPTED SOLUTIONS
PabloVallejo12
Regular Visitor

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 

View solution in original post

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
crobson29
Helper I
Helper I

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
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
PabloVallejo12
Regular Visitor

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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors