Forum Discussion
Metrics as rows in matrix
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
3 Replies
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 # # # Hi,
This should be possible by "Unpivoting other columns". Share data in a format that i can paste it in an Excel file.
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.
