How to Hide Header in Matrix Table

Question

&nbsp;&nbsp;Hi,&nbsp;&nbsp;I am trying hide header part of Matrix table (PowerBI), however, i would like to keep other part of the Matrix Header (Row and Column Value both). Please see screen shot below to see what i am looking for,&nbsp;I have this; Red Highlighted part, i would like to remove or hide because currently I have put DOT "." but does not look good.&nbsp;&nbsp;&nbsp;&nbsp;The expected format is below;&nbsp;&nbsp;&nbsp;&nbsp;As you can see i would like to keep ROW and COLUMN Headers value but would like to hide Headers name. I can do everything else just not getting how would I hide headers.&nbsp;Any Suggestion or Advise? Hope this is enough explanation. If you need more please let me know would be more than happy to share with you.&nbsp;Thanks

v-kelly-msft · Answer

Hi damit23183 ，&nbsp;For matrix,there's no such functionality that can hide the headers.But i have a workaround for you:First create a Rectangle,and set the color of "line" and "fill" to white:Then move the Rectangle to the part where you wanna "hide",press ctrl and right click on the visuals of rectangle and matrix,set "group",as you see below:Then magic happens：Best Regards,KellyDid I answer your question? Mark my post as a solution!&nbsp;&nbsp;

sanimesa · Answer

damit23183&nbsp; You could create a rectangle shape and overlay that part of the matrix.

damit23183 · Answer

Hi,&nbsp;Thanks for your response.&nbsp;Your idea is good but does not look like it will work because when user move their mouse it will be flip flop show off. This is the reason when user can easily see that hidden part.&nbsp;Thanks though for nice trick.&nbsp;Thanks

v-kelly-msft · Answer

Hi&nbsp;damit23183 ,&nbsp;Pls check whether below links will help:https://community.powerbi.com/t5/Desktop/hide-matrix-headers/td-p/497460https://stackoverflow.com/questions/57924019/show-hide-column-in-power-bi-table-matrix-visual&nbsp;If not,I suggest you propose an idea via below link to make this feature come soon.https://ideas.powerbi.com/forums/265200-power-bi-ideas&nbsp;Best Regards,KellyDid I answer your question? Mark my post as a solution!

kristofferwest · Answer

There is another way 🙂In this I have a header over the "green" box, but it is hidden with field formating:&nbsp;This cannot also be applied to columns where you don't want to show totals for a specific column&nbsp;

Forum Discussion

How to Hide Header in Matrix Table

5 Replies

Related content

Matrix table

Sort Column Header in Matrix Table

Matrix table

KPI level matrix table

Matrix table in Power bi