Change matrix visual layout to show data on two rows

[KasperFB]

Hi

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

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

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??

[v-rzhou-msft · Accepted solution]

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.

My Sample:

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.

[KasperFB]

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]

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!

[KasperFB]

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".