Forum Discussion
Matrix - Display Values above Columns
Hi dancarr22,
For Power BI Matrix visual, the value level shows below the column level. Based on your screenshot, I create the similar structure data sample as follows.
Then I create Matix visual like you.
If you want to display data like the format in Tableau, you need to unpivot Value and SpreadCost columns. Please right click your table->Query Editor->select both Value and SpreadCost columns->Unpivot columns(see the button highlighted in yellow background), click apply, you will get the data shown in screenshot.
Then select the Ticker as Row level, the Attribute and MarkerTicker as column level, the Value.1 as Value level, you will get expected result.
Best Regards,
Angelia
Hi dancarr22,
For Power BI Matrix visual, the value level shows below the column level. Based on your screenshot, I create the similar structure data sample as follows.
Then I create Matix visual like you.
If you want to display data like the format in Tableau, you need to unpivot Value and SpreadCost columns. Please right click your table->Query Editor->select both Value and SpreadCost columns->Unpivot columns(see the button highlighted in yellow background), click apply, you will get the data shown in screenshot.
Then select the Ticker as Row level, the Attribute and MarkerTicker as column level, the Value.1 as Value level, you will get expected result.
Best Regards,
Angelia
this is not a practical solution when the table to be unpivoted has 30 fields.
There needs to be a simple way to do this in power bi like there is in excel.
Hi apatnola ,
This answer is from 3 years ago, since then the tool has evolve significantly depending on what you are looking for there are other options. Currently there are calculated groups, options to unpivot only, selected columns or the use of a disconnected table.
What is the result you want to achieve and how is your data is setup?
You compare Power BI with Excel but in both cases if you have the incorrect data format the results will not be achived corretly. Altough the tools look similar they are in fact very different because they are used for different purposes.
Can you share a mockup of your data and expected result?
I am trying to get from
to
Here are the specific fields I have picked so far.
In excel's pivot table fields, you just switch the values and the column headers, that's it. Hopefully, there is a power bi solution short of creating individual measures for each column/value combination that needs to be maintained over time.
Thanks Angelia!
Hi there,
As far as I can tell I have my data set up the exact say way as above and when I add two attributes to the "columns" in my matrix, it will only display the one that is on top in the Visualization pane
I have values as Measures , how Can I do Unpivot.....
