Forum Discussion

dancarr22's avatar
dancarr22
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's avatar
    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

MFelix's avatar
MFelix
Super User
8 years ago

Hi dancarr22,

 

I believe that your question is related with the way you have your data setup, you have multiple measure and adding them to your values area, is your data in the Values area columns or calculated measures?

 

Regards,

MFelix

  • dancarr22's avatar
    dancarr22
    Helper V
    8 years ago

    Hello,

     

    Thanks for your response.

    The data in the values area are numerical data fields which need to be aggregated for the given groups.  They are not measures.

    Need these values to appear ABOVE the columns not below them.

    Please let me know if you require additional info.

    Thanks for your help with this.

     

    Thanks,

    Dan