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

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

Reply
pradeeswar
New Member

Manage relationship in power BI


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)

PIDSAMCITYCOUNTRY
A123ABIBLRIN
B234BOBPUNIN
C345CEZUHCH
D456DENBGHCH
E567EDSWDCUS

Table2 : User membership to various IT groups (5X5 + 1 HEADER)

GROUPA123B234C345D456E567
L1MemberNoMembershipNoMembershipNoMembershipMember
L2NoMembershipNoMembershipMemberMemberNoMembership
L3NoMembershipMemberNoMembershipMemberMember
OPSMemberNoMembershipMemberMemberNoMembership
ADMINMemberMemberNoMembershipNoMembershipMember


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,

1 ACCEPTED SOLUTION
serpiva64
Super User
Super User

Hi,

in order to create a relationship like this

serpiva64_0-1669457769254.png

you need to unpivot in power query your second table to get this

serpiva64_1-1669457824312.png

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 !

 

 

 

 

 

View solution in original post

2 REPLIES 2
pradeeswar
New Member

That helped!
I was able to make a better visual by using 'Slicer' + 'Matrix'.

Thanks a lot

serpiva64
Super User
Super User

Hi,

in order to create a relationship like this

serpiva64_0-1669457769254.png

you need to unpivot in power query your second table to get this

serpiva64_1-1669457824312.png

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 !

 

 

 

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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