Forum Discussion
Managing Relationships
Hi Anonymous ,
Usually we create a bridge table to create a relationship between two tables:
ProgramTable = DISTINCT( UNION( SELECTCOLUMNS('WES - Scores', "Program", 'WES - Scores'[Program]), SELECTCOLUMNS('Respectful Environment', "Program", 'Respectful Environment'[Program]) ) )Many-to-many relationship guidance - Power BI | Microsoft Learn
Then use the fields in the bridge table.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Anonymous ,
Usually we create a bridge table to create a relationship between two tables:
ProgramTable =
DISTINCT(
UNION(
SELECTCOLUMNS('WES - Scores', "Program", 'WES - Scores'[Program]),
SELECTCOLUMNS('Respectful Environment', "Program", 'Respectful Environment'[Program])
)
)
Many-to-many relationship guidance - Power BI | Microsoft Learn
Then use the fields in the bridge table.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you so much! It works. Do you know how I can "tidy up" these relationship? I am not sure how to move the boxes at the very top of the page (it doesn't show as they are all the way up). I highlighed in yellow:
Hi Anonymous ,
Try clicking the Fit to page button in the bottom right corner of the page and dragging the table into place.
Best Regards,
Gao
Community Support TeamUnfortunately it dind't work. Are there other options?
Thanks!
Click the button to the left of the "fit to page" one.
