Trying to get a table to look like how I had it in Tableau

[daniel_krantz_4]

So below is table I have in Tableau. Each of the rows is a column in the original data. This is such a simple table, but man I cannot figure out how to make this in power bi. When doing table or matrix, The "avg. Monthly Utilization" stuff always shows up top with the calendar dates as opposed to being in the far left column. Any thoughts on how to do this? Do I need to reorganize my data in some way to do this powerbi?

[audreygerred · Accepted solution]

Hi! In the matrix, go to the formatting, expand the Values section, then within that expand the Options section and toggle the 'Switch values to rows...' to on. This will put your measures on the rows instead of the columns.

[v-huijiey-msft · Accepted solution]

Hi @daniel_krantz_4 ,

Thanks for the reply from @audreygerred .

I created the raw data based on your description:

Enter Power Query, select the Date column and then perform unpivot column operations on other columns.

The adjusted data looks like this.

Use a matrix visualization object like the one below.

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[audreygerred · Accepted solution]

Hi! In the matrix, go to the formatting, expand the Values section, then within that expand the Options section and toggle the 'Switch values to rows...' to on. This will put your measures on the rows instead of the columns.

[daniel_krantz_4]

Wow, I was really hoping it was a simple solution! I was looking  everywhere for something like that. thank you!

[audreygerred]

You're very welcome!