Forum Discussion
biswad
Advocate I
2 years agoHow to view row data as column without loosing duplicate raw values - Power bi
Hi Friends, I'm working on a dashboard where I have the data in this format t1. t1 Branch OfficialName Role Barnet David Treasure Bedford Mike Secretary Anglesey Andy Pres...
speedramps
Super User
2 years agoTry this ...
Click here to download PBIX from OneDrive
Use a Matrix visual with Branch and Official Name as Rows, the Role as Column and First OffcialName as Value
Please click Accept As Solution and Thumbs up. Thank you
biswad
Advocate I
2 years agoThank you speedramps and Anonymous both solves the answer to the problem, much appriciated all your support, I'm not sure if I could accept both as solution or not, but truely appriciated your help on this.