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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mcadkins
New Member

Mapping a relationship where multiple fields refer to same column.

I am looking for some assistance with a relationship mapping I am trying to pull off.

I have a dashboard that refers to a user in multiple fields by their ID where the tables look something like this.

User Table

User IDName
1Barry
2Larry
3

Garry

4

Jerry

5

Mary

6

Cary

 

Account Table

Account NameProject ManagerAccount ExecutiveInstallation Technician
We Build Stuff125
BuildCo145
Building-R-Us346

 

Is there a way to allow me to relate each of the IDs in the columns of the account tables to the user ID

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @mcadkins ,

Power BI doesn’t allow relationship in model based on multiple columns, but Power Query can join tables with as many as columns we want.

v-luwang-msft_0-1616481962288.png

to learn more details ,you can read the following article:

Relationship in Power BI with Multiple Columns

 

Wish it is helpful for you!

 

Best  Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @mcadkins ,

Power BI doesn’t allow relationship in model based on multiple columns, but Power Query can join tables with as many as columns we want.

v-luwang-msft_0-1616481962288.png

to learn more details ,you can read the following article:

Relationship in Power BI with Multiple Columns

 

Wish it is helpful for you!

 

Best  Regards

Lucien

MattAllington
Community Champion
Community Champion

You need to unpivot your account table first. You do this in power query. Click on account name and then "unpivot other columns". This will give you a single column "value" (which you can rename) and you can then join on this column.  



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.