Manage relationship in power BI

[pradeeswar]

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,

[pradeeswar]

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

Thanks a lot

[serpiva64 · Accepted 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 !