Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

how to hide column header and row header in matrix?

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

 

2 ACCEPTED SOLUTIONS
visheshjain
Solution Supplier
Solution Supplier

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



View solution in original post

visheshjain
Solution Supplier
Solution Supplier

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.

 

Screenshot (296).png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



View solution in original post

9 REPLIES 9
akoren2
Frequent Visitor

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

This is the best!

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

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
Solution Supplier
Solution Supplier

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.

 

Screenshot (296).png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



Anonymous
Not applicable

It works, Thank you!

Glad to help!

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



visheshjain
Solution Supplier
Solution Supplier

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

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



Anonymous
Not applicable

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.1.JPG

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors