Forum Discussion

crobson29's avatar
crobson29
Helper I
2 years ago
Solved

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 unfort...
Need Help
  • PabloVallejo12's avatar
    PabloVallejo12
    2 years ago

    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 

  • Anonymous's avatar
    Anonymous
    2 years ago

    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

crobson29's avatar
crobson29
Helper I
2 years ago

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.