Re: How to Hide Header in Matrix Table

damit23183 · ‎05-07-2020

Hi,

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,

I have this; Red Highlighted part, i would like to remove or hide because currently I have put DOT "." but does not look good.

The expected format is below;

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.

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.

Thanks

kristofferwest · ‎11-25-2020

There is another way 🙂

In this I have a header over the "green" box, but it is hidden with field formating:

This cannot also be applied to columns where you don't want to show totals for a specific column

v-kelly-msft · ‎05-07-2020

Hi @damit23183 ，

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,
Kelly

Did I answer your question? Mark my post as a solution!

damit23183 · ‎05-08-2020

Hi,

Thanks for your response.

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.

Thanks though for nice trick.

Thanks