Forum Discussion
How to view row data as column without loosing duplicate raw values - Power bi
Try 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
Hi biswad ,
Based on the information you provided, since the Rows of the matrix duplicate data will only be displayed once. You can add an index column. Use index and Branch as Rows.
Final output:How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry I meant to Pivot Branch and select Role as Values Column awithout aggregation.
Thank you, I have tried pivoting the branch, but I need to keep the same structure as shown in the second table, if I pivot the branch the branch name goes under "Treasurer","Secretary" and "President". I would like to keep official roles under each role.