Hide Column Headers in Power BI Table Visuals

To hide every column heading in a Power BI table, select the table visual, open Format visual > Visual > Column headers, and switch Column headers off. This removes the heading row from that visual; it does not remove fields, change the data model, or hide column names elsewhere in the report.

What the column-header setting controls

A table visual normally shows a header row above its data. Those labels come from the fields used in the visual, such as a model column called Product or a measure called Total Sales. The header setting controls whether that row is displayed. When it is off, the table’s data rows remain, but the labels that identify the columns are no longer visible.

The setting applies to the table as a whole: it hides all of that visual’s column headers, rather than letting you switch off one heading while leaving the others visible. It is a formatting choice for the selected visual, not a change to the source data or the semantic model. Other visuals and reports using the same fields are unaffected.

That distinction matters when a report is exported, refreshed, or reused. Hiding a heading on the canvas should not be treated as renaming or deleting the field. The field remains available to Power BI, and the visual still contains it. If readers need to identify what each displayed number or text value means, consider adding a different label before removing the heading row.

How to turn off headers in Power BI Desktop

Open the report in Power BI Desktop and select the table visual you want to change.
In the Visualizations area, select Format visual (the paintbrush or formatting icon, depending on the interface).
Open the Visual formatting options and find Column headers. If the section is collapsed, expand it.
Switch the Column headers setting off.
Check the visual at report size and adjust spacing or other formatting if the removed row leaves the table looking unbalanced.

Power BI’s formatting pane can look different across Desktop releases and interface updates. In the newer format pane, the relevant section is under the visual-specific settings, rather than the general settings for the report page. If you do not see it immediately, confirm that a table is selected and use the formatting pane’s search box to search for “Column headers.” A setting may not appear if the selected object is a different visual type.

In the Power BI service, editing a report can expose similar visual formatting options, but the exact experience depends on your permissions and the report’s editing mode. If you only have read access, you cannot change the visual’s formatting there. Make the change in Desktop or ask someone with edit permission to update the report.

Can you hide just one column heading?

The standard table visual’s Column headers switch is an all-or-nothing control. It does not provide a separate visibility toggle for each heading. If you want to keep most headings and suppress one, a common workaround is to rename that field for this visual. In the visual’s field list, open the field’s menu and choose Rename for this visual, then enter a short replacement label. This changes the displayed name in this visual only, not the model’s name.

Some report authors try using a single space as the replacement label to make one heading appear blank. Whether this is accepted and how it renders can depend on the field and Power BI version, so treat it as a presentation workaround rather than a reliable per-column hide feature. It can also create an accessibility problem: users may have no clear label for that column, and a blank heading can make the table harder to interpret or maintain.

A more robust option is to use a concise but meaningful label, such as “ ” replaced by “Qty” or “ ” replaced by “Share,” if the full field name is unnecessarily long. If the heading truly should not be shown, consider whether the column belongs in the visual at all. Removing a field is different from hiding its label: it removes that column’s values from the table as well.

What changes when headers are hidden?

The visible result is straightforward, but a heading row often does more than provide decoration. It tells readers what each column contains, provides a place to interact with a column, and helps distinguish measures from categories. Once it is hidden, readers may need another cue to understand the table. This is especially important when several columns contain similar values, such as current-year sales, prior-year sales, and percentage change.

Column identity: readers no longer see the field names above the values. Add a title, explanatory text, or another clear label when the meaning is not obvious.
Sorting: readers lose the visible heading row as a natural place to discover or use column sorting. Set an appropriate initial sort and check the visual’s available menu options before publishing.
Layout: removing a row changes the visual’s vertical appearance. Review the table height, alignment with nearby visuals, and the space above the first data row.
Data and model: the fields and their values remain in the visual. The setting does not rename fields in the model or remove them from other report pages.

Do not assume that hiding a heading also hides a field from every other way a user might access the report. For example, exporting data and interacting with a visual are separate from how the report canvas is formatted. If the requirement is to prevent users from seeing or accessing particular data, a cosmetic header setting is not a security control. Use the appropriate data permissions and model design for that requirement.

Alternatives when a header-free table is not clear

Sometimes the goal is not really to remove headings, but to make a table cleaner or more compact. Before hiding the whole header row, consider these options:

Shorten the labels: use familiar abbreviations or concise names, while keeping them understandable to the report’s audience.
Explain the columns nearby: add a text box above the table, or use a clear visual title and a short subtitle that defines the order and meaning of the columns.
Reduce header styling: adjust font, background, alignment, or other available header formatting so the headings remain present without dominating the design.
Use a different visual: a card or a set of cards can suit a small number of key measures better than a table. A matrix can suit grouped rows and columns, but it has its own header and layout settings.
Remove unnecessary fields: if a column adds no value to the reader, removing it may be clearer than showing unlabeled values.

These alternatives are useful when readers must compare multiple columns. For instance, a table with Product, Units, and Revenue is difficult to interpret if all three headings disappear. If the table is only a compact list of values whose meaning is stated clearly in a nearby title, hiding the headings may be reasonable.

Table visual versus matrix visual

Power BI’s table and matrix visuals can look similar, but they serve different purposes. A table presents fields as a flat set of columns and rows. A matrix supports a row-and-column hierarchy, grouped headers, and subtotals, so its formatting controls are not identical to those of a table. Do not assume that changing a table’s column-header setting will produce the same result in a matrix.

If your visual is a matrix, select it and inspect its own formatting options for row headers, column headers, and layout. The exact controls available depend on the matrix configuration and current Power BI interface. If the aim is simply to remove a plain heading row from a flat list, use a table visual and its column-header setting. If the data needs grouped headings or a hierarchy, keep the matrix structure and format its labels deliberately instead of choosing a table only to avoid a header.

Common problems and fixes

The setting is missing. First verify that the selected object is a table visual, not a text box, matrix, or another chart. Then open the visual-specific formatting options and search for “Column headers.” The location can shift as Power BI updates its pane, but the selected visual’s formatting controls are the right place to look.

The switch is off, but text still appears above the table. Check whether the text is a separate text box, a visual title, or another element on the page. The column-header setting only controls the table’s heading row; it does not remove a title or nearby text object.

The first row looks like a header. If your source data contains a row of labels as actual data, turning off the visual’s header setting will not necessarily remove that row from the data. Check the fields and query steps that supply the table. In Power Query, confirm that the source’s first row has been interpreted correctly as headers when appropriate.

Readers cannot tell what the values mean. Restore the headers, shorten them, or supply an explicit label elsewhere. A clean-looking table is not useful if readers have to guess whether a number represents dollars, units, a percentage, or a date.

The change does not appear for other report viewers. Confirm that you saved and published the updated report to the intended workspace or app, and that viewers are opening the updated version. A local Desktop change does not automatically update a separately published report.

Frequently Asked Questions

Can I hide column headers in a Power BI table?
Yes. Select the table, open Format visual > Visual > Column headers, and turn the setting off. The table’s data remains visible.

Can I hide only one header in a Power BI table?
Not with the standard table’s overall column-header switch; it hides every heading. You can rename a field for that visual as a workaround, but retain a meaningful label where readers need one.

Does hiding a header remove the column from the model?
No. It changes the visual’s presentation only. The field remains in the model, and hiding its heading does not delete the field or change its values.

Can I hide headers in a Power BI matrix?
A matrix has its own formatting controls for its row and column headers. Select the matrix and inspect its specific formatting options; do not assume the table visual’s setting applies to it.

Why can’t I find Column headers?
Make sure a table visual is selected and that you are looking in its visual-specific formatting options. The pane’s layout can vary by Power BI version, so searching the format pane for “Column headers” can help.

Choosing the right presentation

Hide the header row when its labels are genuinely redundant and the remaining table is still easy to understand. Keep or replace the labels when the values need context, when users compare several measures, or when sorting and accessibility matter. A good test is to show the table to someone who has not built the report: if they cannot explain what each column means without guessing, the heading should remain or its meaning should be stated clearly elsewhere.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.