Forum Discussion
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...
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
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
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