Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 ID | Name |
1 | Barry |
2 | Larry |
3 | Garry |
4 | Jerry |
5 | Mary |
6 | Cary |
Account Table
Account Name | Project Manager | Account Executive | Installation Technician |
We Build Stuff | 1 | 2 | 5 |
BuildCo | 1 | 4 | 5 |
Building-R-Us | 3 | 4 | 6 |
Is there a way to allow me to relate each of the IDs in the columns of the account tables to the user ID
Solved! Go to Solution.
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.
to learn more details ,you can read the following article:
Wish it is helpful for you!
Best Regards
Lucien
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.
to learn more details ,you can read the following article:
Wish it is helpful for you!
Best Regards
Lucien
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
28 | |
26 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |