Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Dear community,
I would like to create a table visual, which shows the months of the year in the columns and different messures in the rows;
When I use the matrix visual, it always adds all the messures withing one row, but I would like to have them underneth each other, like that:
Does anyone know how to do that?
Cheers, Pete
Solved! Go to Solution.
Hi @Pete230
You can add all your measures into Values of the matrix visual, leave Rows empty, and add Month column to Columns.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you for your anwer!
My problen is a little different; I dont have a column "Brand" as refered in your video (screenshot below); instead I have several messures which I would like to be shown in the rows. Is that possible somehow too?
Cheers, Pete
Hi @Pete230
You can add all your measures into Values of the matrix visual, leave Rows empty, and add Month column to Columns.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Pete230 , In matrix visual you can use Switch values on row; nothing on row field and month year of column field.
If you have more than one row field expand using expand icon(reverse square Y) . Use Stepped layout off
refer: https://youtu.be/cN8AO3_vmlY?t=11463
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.