Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | # | # | # |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |