Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I'm a newbie to PowerBI, started a week ago as it is VERY interesting !
I'm trying to do some reporting and I have the below two tables
Table1: User Informtion (5X5 + 1 HEADER)
PID | SAM | CITY | COUNTRY |
A123 | ABI | BLR | IN |
B234 | BOB | PUN | IN |
C345 | CEZ | UH | CH |
D456 | DEN | BGH | CH |
E567 | EDS | WDC | US |
Table2 : User membership to various IT groups (5X5 + 1 HEADER)
GROUP | A123 | B234 | C345 | D456 | E567 |
L1 | Member | NoMembership | NoMembership | NoMembership | Member |
L2 | NoMembership | NoMembership | Member | Member | NoMembership |
L3 | NoMembership | Member | NoMembership | Member | Member |
OPS | Member | NoMembership | Member | Member | NoMembership |
ADMIN | Member | Member | NoMembership | NoMembership | Member |
How can I create a relationship between these two tables ?
I'm trying to use a 'slicer' & 'table' view.
When I select a user(s)it should the membership status of those users against the group table (same as table2 view but only for the selected user)
Any help would be greatly appreciated!
Thanks in advance,
Solved! Go to Solution.
Hi,
in order to create a relationship like this
you need to unpivot in power query your second table to get this
In the attached file you will find all the needed steps
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
That helped!
I was able to make a better visual by using 'Slicer' + 'Matrix'.
Thanks a lot
Hi,
in order to create a relationship like this
you need to unpivot in power query your second table to get this
In the attached file you will find all the needed steps
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |