Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

matrix visual header formatting

Hello - I'm trying to understand how the top left most cell is populated on a matrix visual when you have both column and row values.  It seems to display the name of the rows field, but formats itself to match the columns which is confusing to the report user. See example below.

 

I am looking for either a way to have it display the field name that is in the columns value location or a way to format it to match the row header formatting. Kind of like this:

 

Thanks for any insight you can provide.

 

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi Anonymous

    There is no such option in power bi currently, you could distinguish the "row" and "column" with a workaround as below.

    create a column in the table

    rwo/column = "column"

     

    then add "row/column" in the "Column" field, and click on the "expand" icon on the top-right of the matrix.

     

    Best Regards

    Maggie