Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
Hi,
This should be possible by "Unpivoting other columns". Share data in a format that i can paste it in an Excel file.
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 | # | # | # |