Get ID in Columns Automatically based on RLS

[tejasp]

Hi Team,

I have data like below with multiple ID.

Title	Attribute	Value
1531584	Standard Greeting	No
1531584	Initial Challenge	Yes
1531584	IncidentCreation	Yes
1531584	PrivateNote	Yes
1531584	ConvenientSolution	Yes
1531584	Name	ABC
1532569	Standard Greeting	No
1532569	Initial Challenge	Yes
1532569	IncidentCreation	Yes
1532569	PrivateNote	Yes
1532569	ConvenientSolution	Yes
1532569	Name	PQR
2012458	Standard Greeting	No
2012458	Initial Challenge	Yes
2012458	IncidentCreation	Yes
2012458	PrivateNote	Yes
2012458	ConvenientSolution	Yes
2012458	Name	DEF
1895462	Standard Greeting	No
1895462	Initial Challenge	Yes
1895462	IncidentCreation	Yes
1895462	PrivateNote	Yes
1895462	ConvenientSolution	Yes
1895462	Name	ABC

and I would like to see it like:

	1531584	1532569	2012458	1895462
Standard Greeting	No	No	No	No
Initial Challenge	Yes	Yes	Yes	Yes
IncidentCreation	Yes	Yes	Yes	Yes
PrivateNote	Yes	Yes	Yes	Yes
ConvenientSolution	Yes	Yes	Yes	Yes
Name	ABC	PQR	DEF	ABC

I tried Pivot and unpivot options but, to get ID numbers in columns I had to add all of them manually in "columns".

Any idea how can I get "ID" in the column automatically based on the RLS applied on Name?

Thanks,

Tejas

[tejasp]

@amitchandak  that was very simple, thanks

[amitchandak · Accepted solution]

@tejasp , Can display the same in Matrix Visual with MAx value as values

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual