Forum Discussion

Helper V

8 years ago

Solved

Matrix - Display Values above Columns

Hello, We have a basic matrix with columns, rows and values. We would like the values to appear ABOVE the columns. Right now it only displays the opposite -- values BELOW the columns. How can ...

Need Help

v-huizhn-msft
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

apatnola

Helper I

5 years ago

Thank you Miguel. This is super helpful. I have 15 requested items to visualize. Let me work through the others as there may be other datapoints that i will need to pivot on.

The table the information is coming from is a very detailed table (barcode level) with 30 fields.

Also, there is no "year" in the detailed table exactly. Just a posted date joined to my calendar table. Will it work if i pivot on District - Showroom - Posted Date?

Andre