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
Can we just agree that Power BI lacks a basic funtionality here? 🙂
OP requested a basic thing:
Put a dimension into the columns area of a matrix visual like the year:
2018 - 2019 - 2020
Then add two measures, the following happens:
2018 2019 2020
Meas1 Meas2 Meas1 Meas2 Meas1 Meas2
And what OP wanted, was this:
Meas1 Meas2
2018 2019 2020 2018 2019 2020
This can be achieved in a Pivot table in Excel in 2 seconds. No change of the raw data required.
In Power BI, no chance.
The only thing that comes close:
Go to the format pane of the matrix visual and under VALUES select "Show On Rows".
Not exactly the wanted result, but close enough most time.
Hi Anonymous ,
Depending on the result you need currrently there are several option that you don't need to change the raw data, you may need to create calculation groups for example, or an additional table with your hierarchy.
It's not has direct has in Excel agree with you but this has to do with the way the model works and the engine, altough some things are similar to Excel, Power BI is not to do the same things has in Excel so the functionalities may vary.