Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 !
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
103 | |
103 | |
87 | |
61 |
User | Count |
---|---|
167 | |
136 | |
134 | |
100 | |
86 |