cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rachey
Regular Visitor

Matrix - hide column names

Hi

 

Is it possible to hide the names of the columns when displaying a Matrix? They clutter the visual and don't really add anything so I'm hoping I can get rid of them?

 

Cheers!

10 REPLIES 10
Super User III
Super User III

Re: Matrix - hide column names

@Rachey There isn't an option in the actual formatting options, but you could create a rectangle shape and change it to match your background and just cover the column names... Not optimal, but it would work.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Sean Community Champion
Community Champion

Re: Matrix - hide column names

@Rachey

We may actually get some formatting options with the April Update.

 

So you may (or may not) be able to do this in a few days - 5 days left in April.

 

Until then Eno1978's suggestion will have to do.

devenchj Helper I
Helper I

Re: Matrix - hide column names

covering column header with shape doesn't work if visual pinned to dashboard ?

jestevez
Frequent Visitor

Re: Matrix - hide column names

Column headers--> Font Color (White)

psharm33
Regular Visitor

Re: Matrix - hide column names

Hello

There is no way as such to hide particular column names in your matrix but you can try naming them with " " (i.e blank or space).
Could be used as a workaround.
Or you could just rename your column name with a single character (for e.g "i") and then change its font color as per the background. This would work too 🙂

maddy Advocate II
Advocate II

Re: Matrix - hide column names

Hi ,

 

Is there any solution to this problem ?

I am facing the same issue where i need to hide the column heading. So what i did was i am showing a measure (a text) on top of the coulmn heading. But when i print the report from Power BI service the column heading is also showing even though i have changed the font colors.

 

 

My column headings are dynamically changing so that i cannot simply rename the colunm headers.

 

Regards,

Maddy

maddy Advocate II
Advocate II

Re: Matrix - hide column names

@devenchj 

 

Answer is no

Anonymous
Not applicable

Re: Matrix - hide column names

@maddy 

I have come across the same requirement and below is the alternate solution i found.

 

Step1: Go to field formatting and change the font color to your matrix header color and don't forget to select the option "Apply to header". This will hide the text from the header as the text color matches the header color.

Step2: Now the values has the same color as your header, go to Fields tab and under field conditional formatting you can change the color of value to your previous value color.

 

I know, it has lot of work around, but this is the best solution i can think of as of now. Let me know, if it works!

 

Thank you,

Parac 

 

 

 

 

makcim392 Helper I
Helper I

Re: Matrix - hide column names

isn´t it the same as changing to white the header directly?

 

can you show us a picture example?

 

regards

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors