Matrix Table do not show raw header on the top left corner

[WendyDUFE]

Due to business requirement, the row header on the matrix table does not need to display.

In the snapshot below, the "Category" on the top left corner is not expected to be shown. Is there any matrix table setting can help make it ?

Thank you

 

[MFelix · Accepted solution]

Hi @WendyDUFE ,

You can do it with the formatting options

• Column headers font colour white
• Then go to Field formatting and for each column of your matrix (sales and units)
  • Font colour to black
  • Apply to header

[WendyDUFE]

@MFelix  thanks MFelix, it works.

I have another matrix table with two measures in the value field, configure the subtotal per row level. The requirement is also to hide the left top header. Followed your guidelines, I can hide the measures by making the font color same as the background. 

However, when it comes to hide the column headers,  I can not find the option to tailor make the font color. (the column header is from a column value, not measure.

Do you know in this case, what can I do ?

Thank you

[MFelix]

Hi @WendyDUFE ,

In this case since you are presenting the values in rows and have also a category on column level, aren't quite the same believe you have 2 workarounds:

• Rename the Province on the matrix by a "." that will give you a small dot on top of your column
• Place a white rectangle on top of column header and then group both visualizations

This is just workarounds because there is no way to indivudally format each category value that is what you needed.

[WendyDUFE]

Thanks @MFelix 

[amitchandak]

@WendyDUFE , Change the font color as the background color

[WendyDUFE]

thanks @amitchandak  😀