how to hide column header and row header in matrix?

[Anonymous]

There are two matrixes, stack together and use a shared column header or row header, how to hide the column header or row header?

[visheshjain · Accepted solution]

Hi @Anonymous ,

In my experience so far, you cannot really hide the row or column headers as such.

A workaround would be that you can change the font and background color of the headers, so that they merge with the background of your report page.

I'm all ears if anyone else has any other solution.

Thank you,

Vishesh Jain

[akoren2]

You can rename the column headers as spaces. That pretty much removes them. 

[Data_Analyst905]

How do you rename column headers though? 

[akoren2]

In the column selection pane on the right, right click on the column that you have dropped for the visual and click on rename

[SarahHope]

This is the best!

[MarkPalmberg]

I hate that this is the most elegant solution here. Bravo.

[akoren2]

Being a Power BI professional has nothing to do with BI or programming but an art of finding workarounds and an epitome of "its not stupid if it works..."

[visheshjain · Accepted solution]

Hi @Anonymous,

Try layering both the visuals as you require, from the 'Selection' pane.

Then select the bottom visual and from the 'Formatting' Pane of the visuals turn on the 'Maintain Layer Order'.

Also, turn off header icons for the visuals.

This should lock the layering of the viusals to the their place.

However, since you are always in the edit mode in the desktop, this will work only in the service.

Hope this solves your problem and if it does, please kudos the reply and mark it as the solution, so that others can reach the solution faster.

Thank you,

Vishesh Jain

[Anonymous]

It works, Thank you!

[visheshjain]

Glad to help!

[visheshjain · Accepted solution]

Hi @Anonymous ,

In my experience so far, you cannot really hide the row or column headers as such.

A workaround would be that you can change the font and background color of the headers, so that they merge with the background of your report page.

I'm all ears if anyone else has any other solution.

Thank you,

Vishesh Jain

[Anonymous]

Thank you.  Set the font and background color into white the size of column/row header still exists,  if Iput it under the matrix which have headers, so if  click the matrix in the bottom, the upper matrix would be hinded by the bottom matrix, the area in the picture. Is there any solution? Thank you.