cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Pete230
Helper II
Helper II

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 II
Helper II

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors