Forum Discussion

WendyDUFE's avatar
WendyDUFE
Icon for Helper III rankHelper III
5 years ago
Solved

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

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

 

 

  • 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

     

6 Replies

  • 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's avatar
      WendyDUFE
      Icon for Helper III rankHelper III

      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's avatar
        MFelix
        Icon for Super User rankSuper User

        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.