Metrics as rows in matrix

[bo_afk]

Hi,

I have a dataset which includes the following columns: Category, sales, cost, margin.

I would like to create a matrix such that Category is at the top, with the metric names on the side and values inside the table, such as below.

	Category A	Category B	Category C
Sales	#	#	#
Cost	#	#	#
Margin	#	#	#

However, when I move the "sales" column as a row, it displays all the possible sales values as opposed to the column name "sales". Have been playing around with the matrix but nothing seems to work. Is this actually possible?

Thanks

afk

[dyingod]

Just for archiving and making sure others find this:

I guess Power BI eventually added the functionality below to make this less painful. Here is a link to where I found it.

https://www.thelemondataguy.com/how-to-change-a-grid-layout-to-horizontal-in-power-bi#:~:text=So%2C%....

[Ashish_Mathur]

Hi,

This should be possible by "Unpivoting other columns".  Share data in a format that i can paste it in an Excel file.

[v-frfei-msft]

Hi @bo_afk ,

Did you want to create a matrix as below? As the data you describe, seemed that we cannot achiev that. As table visual is different with matrix.

	SALEs	Category B	Category C	Category A
Cost	xx	#	#	#
Margin	xx	#	#	#