To hide every column name in a Power BI table visual, select the visual, open Format visual > Visual > Column headers, and switch the setting off. To hide just one name, Power BI has no universal per-column hide-header switch; rename that field for the visual or choose another approach depending on what you want to conceal.
What “hide a column name” can mean
The phrase can describe several different tasks, and they have different effects. You might want a cleaner table with no header row, remove one label while keeping its values visible, keep a field out of the report author’s field list, or remove the column from the model altogether. These are not interchangeable actions.
Start by identifying the intended result:
- Hide all headers in one visual: Turn off Column headers in that visual’s formatting options.
- Change one displayed label: Rename the field for that visual, leaving its model name unchanged.
- Keep a field out of the field list: Hide it in report view in the model.
- Remove the values from the visual: Remove the field from the visual’s field well.
- Remove the column from the model: Delete it in Power Query, if it is not needed for analysis.
Choosing the right meaning matters. For example, hiding a field from the field list does not make its data confidential, and turning off a visual’s headers does not remove the fields or their values.
Turn off all column headers in a table visual
In Power BI Desktop, select the table visual on the report canvas. In the Format visual pane, open the Visual section, find Column headers, and turn the setting off. The table’s header row disappears, while the rows and values remain. The change applies to the selected visual, not every table on the page or in the report.
Power BI’s pane layout and section names can vary slightly between releases and depending on whether the newer on-object interaction experience is enabled. If you do not see the setting immediately, make sure the table is selected, open its formatting controls, and look under the visual-specific formatting options rather than the general page or report settings.
This is usually the simplest solution for a compact table where labels are obvious from context, such as a single-column list of product names. It is less suitable for a table with several numeric fields: without headers, a reader may not know whether a number is a quantity, price, or margin. Consider adding a title, explanatory text, or another clear cue before removing all labels.
Turning off headers is a visual-formatting change. It does not change the underlying column names, data model, measures, relationships, or other visuals. You can turn the headers back on later using the same control.
Can you hide just one column name?
There is no general-purpose setting in the standard Table visual that removes the header for exactly one column while leaving the other column headers displayed. The header toggle applies to the whole visual. If one label is confusing or too long, the most reliable built-in alternative is to give that field a better display name for that visual.
To do that, locate the field used by the table in the visual’s Build or field-well area. Open its context menu and choose Rename for this visual, then enter the shorter label. The wording and location of the field-well controls can differ slightly across Power BI Desktop interface versions. A visual-specific rename changes only the label in that visual; it does not rename the column throughout the semantic model or change references in other report visuals.
For instance, a model field called Net Sales Amount (Local Currency) might appear in one compact table as Net sales. That is often more helpful than trying to make the label invisible. If the visual needs no header at all, use the all-headers-off option and make the context clear elsewhere.
Some reports use a blank-looking character as a workaround for a header label. Such tricks can behave inconsistently, may be difficult for screen-reader users, and can make the field hard to identify when editing. They are not the same as a supported per-column hide setting. Prefer a meaningful short label or a visual designed for the intended presentation.
Hide a field from the report field list
If your goal is to prevent report authors from accidentally choosing a technical field, hide it in report view. In Power BI Desktop, select the column in the Data or Model view and use the context-menu command Hide in report view. In Model view, you can also select the field and set its Is hidden property in the Properties pane, where available.
This changes the field’s visibility to report authors in the field list; it does not delete the column or remove its data from the model. A hidden field can still be useful for relationships, calculations, sorting, or other model purposes. Hiding a key column from the field list, for example, can make a curated model easier to use while preserving the relationship behind the scenes.
Do not treat this as a security feature. A hidden field is not a guarantee that users cannot access its data, and it does not substitute for row-level security, object-level security, or appropriate permissions. If the information must not be available to report consumers, use the relevant security controls and avoid loading sensitive data that the audience should never access.
Also, hiding a field from report view is different from removing it from a visual. It is a modeling choice intended to shape the authoring experience, not a way to conceal a displayed table heading.
Remove a column from a visual or from the model
If the values themselves should not appear in a particular table, select the visual and remove the field from its field well. This leaves the model intact and affects only that visual. It is the right choice when the column is unnecessary in the table but still supports other report pages, calculations, or relationships.
If a column is genuinely unnecessary in the model, remove it in Power Query. In Power BI Desktop, choose Home > Transform data to open Power Query Editor, select the column, and use Home > Remove Columns. Then apply the query changes. Removing a column changes what the query loads into the model, so check whether measures, relationships, sorting, or other queries depend on it before doing so. If the field is needed for a calculation or relationship, deleting it may break report behavior.
These options form a useful distinction: formatting changes what a visual displays; removing a field from a visual changes that visual’s contents; hiding in report view changes the authoring field list; removing in Power Query changes the model’s available data. Use the least disruptive option that meets the requirement.
Table visuals, matrix visuals, and other alternatives
The steps above are for the standard Table visual. A Matrix visual has its own formatting controls for row headers, column headers, and values because it organizes fields into a hierarchy. If you are using a matrix, select it and inspect the Matrix-specific options in the Format visual pane; do not assume that the Table visual’s Column headers control will produce the same layout.
When a reader needs the data but not a conventional table heading, consider a different visual rather than forcing a table to behave unusually. A Card can show one key value with a clear title, while a text box can explain a group of values. A chart may make categories and measures easier to understand through its axes, legend, and title. The best choice depends on how many fields the audience must compare and whether the labels are essential to interpreting the data.
Another practical option is to keep the header row and improve its wording, size, or visual styling. A concise label such as Units is often easier to scan than a long source-system name. Avoid styling that makes text indistinguishable from the background merely to simulate hiding it: it can leave wasted space, reduce contrast, and make the report confusing or inaccessible.
Common problems and checks
- The setting is missing: Confirm that the selected object is a standard Table visual, not a Matrix or another visual. Then check the visual-specific Format options.
- Only one header needs to go: The standard table header toggle affects all headers. Rename the field for that visual or redesign the table instead.
- The field still appears in the model: Turning off headers is not a model change. To remove a displayed value, remove the field from the visual; to remove a model column, edit the query.
- A hidden field is still usable: That is expected when it has been hidden in report view. The field remains in the model for modeling purposes.
- A renamed label changes elsewhere: Check whether you chose the visual-specific rename command or renamed the model field itself. The latter affects the model and can change what authors see in other visuals.
After making a change, review the report in reading mode or publish it to the intended audience’s workspace as appropriate. Check that the remaining labels, title, and surrounding text still make the data understandable. Also consider how the visual behaves when filters change: a table that seems self-explanatory with one category may become ambiguous when several categories appear.
Frequently Asked Questions
How do I hide column headers in Power BI?
Select the table visual, open Format visual, expand Visual > Column headers, and turn the option off. This hides the header row for that visual, not for every table in the report.
Can I hide only one column header in a Power BI table?
The standard Table visual does not provide a general per-column hide-header switch. You can rename that field for the visual, remove it from the visual, or choose a layout that does not need the label.
Does Hide in report view hide a column from report users?
No. It hides the field from the authoring field list, but it does not delete the data or provide data security. Use appropriate security features and permissions when access must be restricted.
How do I hide a column without deleting it?
For authoring, use Hide in report view on the column. For a particular table, remove the field from that visual. Both preserve the column in the model, but they solve different problems.
Can I hide a column name in Power BI Service?
Report formatting and modeling options depend on whether you are editing a report or working with its semantic model and on the permissions available to you. For reliable model changes, use Power BI Desktop and publish the updated report or model as needed.
Choosing the right fix
Use the header toggle when every heading in one table can disappear without making the values unclear. Use a visual-specific rename when one label needs shortening or clarification. Hide a field in report view to make a model easier for authors to browse, and remove it from a visual when its values do not belong in that display. Reserve Power Query removal for columns that the model truly does not need. Keeping these actions distinct avoids accidental data loss and makes the finished report easier to understand.
Related
- Event Checklist Template Excel: Build and Use One
- Event Planning Checklist Template Excel: Build Your Own
- Environmental Audit Checklist Excel: Build and Use One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Worksheet Password Remover: Safe Ways to UnlockAn Excel worksheet password remover is usually a tool or method for taking protection off a sheet, but…
- How to Close an Excel Sheet with a Keyboard ShortcutTo close the active Excel workbook in Microsoft Excel for Microsoft 365 on Windows, press Ctrl+W or Ctrl+F4.…
- Jump to a Row Number in Excel: Go To, Name Box, and MoreTo jump to a specific row in Excel for Microsoft 365 on Windows, press Ctrl+G, type a cell…
- Insert 0 in Excel Before a Number: Text or FormattingTo put a leading zero in front of a value in Excel, use a custom number format if…
- How to Merge Cells in Google Sheets: Steps and TipsTo merge cells in Google Sheets, select the cells, then choose Format > Merge cells and pick a…
- How to Average Data in Excel Across Different SheetsTo average the same cell across several worksheets, enter a formula such as =AVERAGE(Jan:Mar!B2) when the sheets are…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.