cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KasperFB
Frequent Visitor

Change matrix visual layout to show data on two rows

Hi

 

I'm currently presenting performance data in a matrix with the below format:

KasperFB_0-1669809756010.png

KasperFB_1-1669809814573.png

To easier get an overview of the two value sets I would like to present the matrix in the below format

KasperFB_2-1669809935097.png

I've tried reading about the 'drill down' and 'Stepped layout' actions, which I suspect is the way to go. However I must admit I'm unable to figure it out. Can anyone please help??

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @KasperFB ,

 

Do you want base on row instead of column to show the columns in matrix-value-field? Here I suggest you to try "Switch values to row" function.

RicoZhou_0-1669879544537.png

My Sample:

RicoZhou_1-1669879676644.png

 


Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
RicoZhou
Community Support
Community Support

Hi @KasperFB ,

 

Do you want base on row instead of column to show the columns in matrix-value-field? Here I suggest you to try "Switch values to row" function.

RicoZhou_0-1669879544537.png

My Sample:

RicoZhou_1-1669879676644.png

 


Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Rico Zhou

This is exactly what I was trying to do. 

The "Switch values to row" function did the trick. 

Thank you very much for your assistance 🙂

NikhilChenna
Continued Contributor
Continued Contributor

hi @KasperFB ,

 Its very simple, if you have the Availability and Corrected as values in one column. If , yes then you can directly drag and drop it in the Rows option below the Unit.

 

Regards,

Nikhil Chenna

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

 

Nikhil Chenna

 

I'm not sure what you mean. I have the values as two seperate columns yes.

When I drag and drop them to the rows under the unit, it divides the rows into the values instead of "uptime" and "incl service".

KasperFB_0-1669819459305.png

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.