Power BI – How to get measures in rows in matrix

What is this about

There are a lot of situations you can meet while working with PowerBI. One of these situations is that you need to have your measures in rows (not in columns as default). See. picture below.

How to do that

I suppose you have prepared data sources and created model in PowerBI.

Choose matrix in PowerBI desktop.

Next step is to create measures and insert the fields into the matrix.

 

When you do the step before, you get the following output:

 

But you want to have measures in rows not to columns. So, go to the “Format pane”.

Go to the values.

And enable “Show on rows”.

After this step you will have your wished visual.

I have been dealing with MS SQL Server for several years. I enjoy both scripting and server administration. Joyful Craftsmen allowed me to deepen my knowledge on cloud solutions as well. That’s why I’m happy to share with you what I’ve learned about migrating data to Azure.

LUKÁŠ KARLOVSKÝ
Data Engineer
LinkedIn

5 Comments. Leave new

  • Ricardo Freire
    19. 2. 2024 20:52

    Perfect, solved all my problems! Thanks a lot!

    Reply
  • Shu-Yun CHENG-LOUVEL
    28. 3. 2024 11:46

    Thank you for this article, helps me a whole lot!

    Best Regards,

    Reply
  • This option is not held when exporting a report. Is there any solution? Thank you.

    Reply
  • Thank you so much, I spent ages trying to figure this out and it was so simple!

    Reply
  • Thomas Laursen
    30. 7. 2024 16:48

    How du you show “row categories” by measures – instead of showing measures by “row categories”? This is possible in excel pivots.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed