Forum Discussion
Matrix - Display Values above Columns
- 8 years ago
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 far ,
Currently there is another solution that is the creation of a Field parameter
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Hi MFelix,
Im aware of field parameters already. Can you explain how should these be used for this solution?
Thanks!