Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pete230
Helper III
Helper III

table visual with messures in rows

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:

Pete230_0-1688720245745.png

Does anyone know how to do that?

Cheers, Pete



1 ACCEPTED SOLUTION

Hi @Pete230 

 

You can add all your measures into Values of the matrix visual, leave Rows empty, and add Month column to Columns. 

vjingzhang_0-1689154117304.png

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
Pete230
Helper III
Helper III

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?

Pete230_0-1688979156342.png


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. 

vjingzhang_0-1689154117304.png

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors