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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
brunakopik
Helper I
Helper I

Managing Relationships

Hello,

 

I am not able to connect the Program columns below:

brunakopik_0-1735587962512.png

 

And: 

brunakopik_1-1735587986303.png

 

I get this message:

brunakopik_2-1735588020788.png

 

 

Any suggestions?

 

Thank you!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @brunakopik ,

 

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])
    )
)

vcgaomsft_1-1735611687687.png

Many-to-many relationship guidance - Power BI | Microsoft Learn

Then use the fields in the bridge table.

vcgaomsft_0-1735611584972.png

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

View solution in original post

11 REPLIES 11
Anonymous
Not applicable

Hi @brunakopik ,

 

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])
    )
)

vcgaomsft_1-1735611687687.png

Many-to-many relationship guidance - Power BI | Microsoft Learn

Then use the fields in the bridge table.

vcgaomsft_0-1735611584972.png

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:

 

brunakopik_0-1736203515935.png

 

Anonymous
Not applicable

Hi @brunakopik ,

 

Try clicking the Fit to page button in the bottom right corner of the page and dragging the table into place.

vcgaomsft_0-1736214417260.png

Best Regards,
Gao

Community Support Team

Unfortunately it dind't work. Are there other options?

 

Thanks!

Click the button to the left of the "fit to page" one.

That works, thanks so much!

brunakopik
Helper I
Helper I

it's because we need the data for 2022 and 2024 and for many different program areas

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Unfortunately I can't upload my file...

lbendlin
Super User
Super User

Can you please explain why you have duplicate rows in the second table?

 

What is your expected outcome?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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