Formatting Columns into Rows in Power BI

At PPM Works, our team is always creating new Power BI reports for customers and for our internal consumption. Since every report request is different we are always learning about new custom visualizations and formatting tips and tricks. One formatting option that is hard to find is the ability to take column values and group them on rows.

The Matrix table is great visualization for displaying data in a table.

As you can see from the screenshot below, the values are displayed in columns. I would prefer to visualize the values in the column and the fields in rows.

 

power bi matrix table.

Under formatting expand the Values section and turn on the Show on rows. This will group the values rather than display them separately in columns.

power bi matrix table                        power bi matrix table

Now the data is grouped by Business Unit and the values for each field can easily be read.

power bi matrix table

 

Find this helpful? Make sure to email Subscribe to our Blog