cancel
Showing results for 
Search instead for 
Did you mean: 
PriscillaCamp

Hide a Column Header on a Table in Power BI

INTRODUCTION

Recently, I was asked to hide the column header 'Over/Under'. There are a few ways to solve this, and I will show you my approach. Below is my table before and after.

Capture1.PNG

Capture2.PNG

STEPS

PriscillaCamp_2-1624406327976.png

We want the name of the 'Over/Under Field' to be blank. If you try to erase the verbiage on the fields pane by highlighting the text and hitting enter, the verbiage will reappear. In order to hide this, you will need to:

1. Go to your Start menu and type Character Map.

2. In the dialogue box, select the Font Courier New.

3. Select Advanced View.

4. In the ‘Go to Unicode’ option select 200C.

5. In the character field press the ‘Select’ button and then the ‘Copy’ button.

PriscillaCamp_3-1624406392646.png

6. Go back to the values section, and in the Over/Under Value right click rename and paste in the character you copied. You will now see the field is blank.

7. Your table Column Header 'Over/Under' is now hidden.

Capture2.PNG

CONCLUSION

Please leave me a comment and let me know how this solution works for you. Or if you have any ideas you would like to share.

To find out more about me, please visit my page itdatadiva.com. You can also follow me on Twitter @itdatadiva or on LinkedIn https://www.linkedin.com/in/itdatadiva/

 

Comments

I thought you could use a blank space but you cannot. This does the trick!