I have a dataset as described in top table. I need to create a matrix visual as with bottom table by placing columns in specific categories so that users can easily distinguish them. Closest I got was by using matrix with stepped layout but I still do not know how I can implement categories/groups on column level. Any suggestions?
Hi @Anonymous
I think you have to do 2 main things - unpivot columns in Power Query and add a category column where you specify if it is Interim or Master product.
Then when your data is in proper format you can simply put it in a matrix.
Please see the test pbix file here: https://filetransfer.io/data-package/NTRyDpV0#link
Hi @Anonymous
I think you have to do 2 main things - unpivot columns in Power Query and add a category column where you specify if it is Interim or Master product.
Then when your data is in proper format you can simply put it in a matrix.
Please see the test pbix file here: https://filetransfer.io/data-package/NTRyDpV0#link
Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
