Blog

Hide a Column Header on a Table in Power BI

Recently, I was asked by my supervisors 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.

Steps

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.

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.

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.

Data Diva

Priscilla Camp is a Business Intelligence and Analytics Specialist at the University of Central Florida. She has 10 years of experience in the field of IT working as a Business Intelligence Analyst. Priscilla started her career working for a startup small business in 2010 and several years later moved over to the Higher Education Industry where she currently resides. Priscilla's focus is T-SQL, Data Warehousing, MS Power BI, and B.I. Strategy.

This Post Has 3 Comments

  1. Adriano April 22, 2020

    Great little trick to quickly hide a column name

  2. Adriano April 22, 2020

    This is a quick trick to hide the column header in a Power BI table visual

  3. Nava April 27, 2020

    Hey, thats a nice trick. Thanks for sharing.

    BTW, is there any option to hide the while headers? I have some scenarios where I only need the rows (without column names)

Comments are closed.