Forum Discussion
Hiding Matrix row headers
Try this:
1. Create measues:
1 = blank()2 = blank()etc.2. Add measures to your matrix where you want a blank line:3. Use field formatting to make foreground and background white for your new measures;It should look like this:
Thanks for the feedback parry2k. I assume when you say foreground color you are referring to font color. Under field formatting, I have the font color and the background color both set to white. This hides the values but not the row header. I need to hide both. Here is screen shot of what matrix row headers look like today:
There is an option below the Field Formatting where you can choose whereyou want to apply the Format you made.
I have "Apply to header" turned on, but it does not affect the header at all.
You will be able to hide the font in the Row Headers if you change the font color and background color to white.
https://community.powerbi.com/t5/Desktop/hide-matrix-headers/m-p/498078#M232309
Currently it doesn't seem that it is an option to change just one or a few Column Headers though, although there are a few workarounds.
- You can try naming them with " " (i.e blank or space)
- You could create a rectangle shape and change it to match your background and just cover the column names
Thanks for all the suggestions. I tried to leave the measure name blank or add a space for the name but I get the message "model object names must be non-empty". I tried to hide the row header with a text box but the text box renders in different locations on the page depending on whether the user is viewing the report from a desktop, laptop, or ipad due to different screen sizes. In other words, the text box may hide a valid row header.
It can be maddening to do something in Excel so easily, like hiding or removing a row header, and so difficult or impossible in Power BI. If anybody has a eureka moment, please share :)