cancel
Showing results 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

Microsoft Employee

## Matrix - measure on rows (not on the last position)

Hi everyone.

I have a Matrix with 3 Rows, 1 Column and a couple of Measures on the Values. I need to place those Measures on the Rows, and I know the option "Show On Rows" allows just that. The thing is that I need the Measures (the values) to be shown between Row 1 and Row 3 (as the 2nd Row), and not on the last position (4th Row). To make it clearer, this is what happens:

Row 1 (Field) - Row 2 (Field) - Row 3 (Field) - Row 4 (Measures).

And this what I need to have:

Row 1 (Field) - Row 2 (Measures) - Row 3 (Field) - Row 4 (Field).

Is this possible? Can I not only place my Measures on Rows but choose in which order they will be shown?

Thanks!

3 REPLIES 3
Community Champion
@BeatrizSilveira
Check out this thread which tackles a similar challenge:
https://community.powerbi.com/t5/Desktop/Calculation-within-a-table-visual/m-p/921521#M441665

You can sort the order of the rows by changing the Row Index

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Super User

Can you share some sample data and required output in a visual manner. Not very clear as of now.

Microsoft Employee

Thank you for your response, and sorry for the unclear explanation.

I’ve attached two pictures that I hope can make it a bit clearer. The “Matrix_as_is” shows the matrix that I have at the moment, and the numbers show the current position of the rows. Number 4 are my measures, because I have the “Show on Rows” option enabled.

The ”Matrix_to_be” shows the Matrix like I would like it to be ordered. In position number 1 I would have the same field as before, but right below I would have all my measures. Position 3 and 4 would be occupied by the other fields.

Like I said before, it’s just a matter of not only placing the values in the rows, but at the same time, if I had like 10 fields placed in the Rows, I could choose in which position my values would be shown if I had the “Show on Rows” enabled. By default, the values are shown in the last position of the row.

Announcements

#### 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 Monthly Update - June 2024

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

#### 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
Top Kudoed Authors