Data Visualization, Microsoft Technologies, Power BI

You Can Now Put Values On Rows In Power BI

Back in January 2016, I wrote a blog post explaining a DAX workaround that allows you to put measures on rows in a matrix in a Power BI report. I’m happy to say that you no longer need my workaround because you can now natively put measures on rows in a matrix in both Power BI Desktop and

This is accomplished via a new formatting option for the matrix.

As a quick example, I made a table with years on columns and measures in my values (and nothing on rows). I added three measures: Sales Amount, Total Cost, Gross Margin.

Initially, my matrix puts the measures across the columns.

But I can change that in the formatting options.

Find the Values section on the formatting pane and look for Show On rows. Toggle that switch to On.

And that gives you the three values on rows.



7 thoughts on “You Can Now Put Values On Rows In Power BI”

  1. I don’t see options for Rows, Columns, and Values on my Power BI desktop.

    I see options for “Page level filters”, “Report level filters”, “Values”.

    How can I see the options for “Rows” and “Columns”?

    1. Hi, Michael. You must add the matrix to the page and then have the matrix selected to see the rows, values, and columns. They will be where you see values. If you are only seeing values, you have most likely selected a table instead of a matrix.

      1. Yes, I figured it out late Thursday night. But Meagan thank you so much for replying to my question; you have no idea how much I appreciate it.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s