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
anee123
Helper I
Helper I

Need to custom format the Matrix visual, I want to show row values side by side.

Hi,

 

I am using matrix visual and am getting the below result.

 

anee123_0-1611813622282.png

 

I want the row values to be side by side and not like a drilldown or collapsable + button..

 

The output should look like below and also we need the Total should come first and then individual values, usually Total comes at last.

anee123_1-1611814155916.png

 

1 ACCEPTED SOLUTION
themistoklis
Community Champion
Community Champion

@anee123 

 

If you want the row values to be side by side .. select format on visual --> Row Headers --> Stepped Layout should be off. Also from Row Headers you can tick off the +/- icon

 

If you want to show totals on top, select the visual and then Format --> Subtotals --> Row subtotal Position to Top

 

To expand all the columns --> Right click in any cell on first column --> Expand --> All

View solution in original post

1 REPLY 1
themistoklis
Community Champion
Community Champion

@anee123 

 

If you want the row values to be side by side .. select format on visual --> Row Headers --> Stepped Layout should be off. Also from Row Headers you can tick off the +/- icon

 

If you want to show totals on top, select the visual and then Format --> Subtotals --> Row subtotal Position to Top

 

To expand all the columns --> Right click in any cell on first column --> Expand --> All

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.