To hide column headings in a Power BI table, select the visual, open Format visual > Visual > Column headers, and switch the setting off. In a matrix, turn off Column headers or Row headers separately, depending on which labels you want to remove.
What “column header” means in Power BI
A column header is the label at the top of a column in a table visual, such as “Product,” “Region,” or “Total Sales.” A matrix has both column and row headings: its column headings identify the fields or measures laid out across the top, while its row headings identify the categories or hierarchy down the left side.
These are different from the visual header: the icons that can appear above a selected visual, such as the ellipsis menu, focus mode, or export options. Hiding a table’s column headings does not, by itself, hide those icons. It also does not rename or remove a field from the semantic model; it changes how the selected visual is presented.
Hide the header row in a table visual
In Power BI Desktop, select the table on the report canvas. Open the Format visual pane, select the Visual tab, and expand Column headers. Switch the setting off. The labels at the top of the table disappear, while the data rows remain.
- Click the table visual you want to change.
- Open Format visual (the paintbrush icon in the Visualizations area in the standard Desktop layout).
- Choose the Visual tab, rather than General.
- Expand Column headers and turn the option off.
The exact location can look a little different across Power BI interface updates. If the pane is using on-object interaction or a newer layout, select the visual and locate its formatting controls; search within the Format pane for “Column headers” if the card is not immediately visible. The equivalent formatting option is available when editing a report in the Power BI service, although available controls depend on whether you have edit access.
To restore the labels, return to the same card and turn the setting back on. The change applies to the selected visual, not every table in the report. You can therefore keep headings on a detailed table while removing them from a compact summary elsewhere.
Hide headings in a matrix
A matrix separates its heading controls, which is useful when you want to remove only one part of its layout. Select the matrix and open Format visual > Visual. Expand Column headers to hide the headings across the top, or expand Row headers to hide labels along the left side. The setting names and available options can vary slightly with Power BI updates and the selected visual.
Be cautious with Row headers: they are not simply a decorative title. They identify the row categories, and in a matrix with multiple row fields they help readers understand the hierarchy. Turning them off can make the values difficult to interpret and can remove useful navigation cues, such as the context for expanded levels. If you only want to remove a field name or adjust the hierarchy’s appearance, inspect the other options in the Row headers card before switching off the whole section.
Likewise, hiding matrix column headings does not necessarily remove the numbers or categories underneath them. It removes the labels that explain what those columns represent. Check the rendered matrix at different drill and expand levels after changing the setting.
Can you hide just one column heading?
The standard table visual’s Column headers control hides or shows the header row as a whole; it is not a switch for selectively hiding one heading while leaving the other headings visible. If you need a single label gone, first consider whether the field itself belongs in the visual. Removing a field from the table removes that column and its heading, but it also removes the data, so this is appropriate only when the values are not needed.
If the data should stay but the displayed wording is the problem, use a clearer, shorter label instead. In the visual’s field well, right-click the field and choose Rename for this visual when that command is available. This changes the label for that visual rather than renaming the underlying model field, which helps avoid unintended changes to other report pages. A name such as “Sales” may fit better than “Sum of Net Sales Amount” while still telling the reader what the values mean.
When a design truly requires a blank label for one column, there is no general per-heading hide switch in the standard table visual. A separate visual or a carefully aligned text box can imitate a custom heading row, but this adds maintenance: column widths can change, and the added labels may not travel with the table when users export or view it on a different screen. Prefer a meaningful short heading whenever possible.
What changes when headers are hidden?
Hiding the headings can make a small card-like table look cleaner, especially when the surrounding page already explains the values. For example, a table showing a single row of monthly totals may be easier to scan without a repeated heading row if its title clearly states the measure and period. But in a table with several measures, removing labels can leave readers unsure which value belongs to which measure.
- Sorting: Users lose the ability to sort by clicking a visible column heading. Set the intended sort order before hiding headers, and check whether the visual’s other available sort controls meet your needs.
- Interpretation: Without labels, numbers such as 240 and 18% may be ambiguous. A nearby title, subtitle, or explanatory text can supply essential context.
- Accessibility: Visible labels help people understand a table, including readers using assistive technologies. Avoid removing them when the visual’s meaning is not obvious from its surrounding content.
- Export and reuse: Hiding a heading is a presentation choice, not a model change. Exported results or other ways of accessing the data may handle labels differently, so verify the output if users rely on export.
In short, consider whether the issue is visual clutter, a long field name, or a genuinely unnecessary column. Those are different problems and may call for different fixes.
Column headers versus visual header icons
If the items you want to remove are icons above the visual rather than words inside its first row, you are looking for the visual header settings. Select the visual and open Format visual > General; look for the header or header-icons controls. Depending on the Power BI version and visual, you may be able to manage particular icons there. The ellipsis menu, for example, is not a table column heading.
Turning off column headings will not necessarily remove the visual’s title either. A title is generally controlled separately in the visual’s formatting options under General. Similarly, hiding the visual header icons does not remove the labels in the table itself. Identify whether the unwanted element is a column name, visual title, or toolbar icon before changing settings.
Alternatives to hiding every heading
Often a small formatting change solves the original problem with fewer usability costs. If headers feel too tall or crowded, adjust the header text size, font, background, alignment, or padding in the Column headers options where those controls are available. Shorten a visual-specific field name, widen the column, or use line wrapping if it suits the design. These approaches preserve the basic information while giving the table a lighter appearance.
For a dashboard tile with one obvious value, a card visual may be more appropriate than a table with its headings removed. For a highly designed layout, separate text labels and data visuals can offer more control, but require alignment and responsive-layout checks. If readers need to compare categories or identify individual measures, keep the headers and reduce visual noise elsewhere—for instance, by removing redundant gridlines or unnecessary columns.
Common problems and checks
- The setting is missing: Confirm that the visual is selected and that you are on the Visual formatting tab. A chart, slicer, or card has different formatting cards from a table or matrix.
- The wrong thing disappeared: Check whether you changed Column headers, Row headers, the visual title, or the visual header icons. These controls affect different parts of the report.
- Only one heading should go: The standard table’s main header toggle is not a per-column hide control. Rename the field for that visual or reconsider whether the column is needed.
- The table became hard to understand: Restore the headings or add concise context that clearly identifies each value. Test the page at its normal viewing size, not just while editing.
- Changes seem inconsistent: Verify that you selected the intended visual and that you are editing the correct report page. Similar-looking tables are separate visuals with their own formatting.
Frequently Asked Questions
Can I hide column headers in Power BI without deleting the data?
Yes. Turn off Column headers in the selected table visual’s formatting settings. The fields and values remain in the visual; only the displayed heading row is hidden.
Can I hide one header but keep the others?
Not with the standard table visual’s overall Column headers toggle. Rename that field for the visual, remove the entire column if its data is not required, or build a custom layout if a single blank heading is essential.
Does hiding headers change the data model?
No. It is a visual-formatting change. It does not rename a model column, delete data, or change calculations.
How do I hide row headers in a Power BI matrix?
Select the matrix, open Format visual > Visual > Row headers, and turn off the relevant option. Review the result carefully because row headers identify categories and hierarchy levels.
Why are the ellipsis and other icons still showing?
Those are visual header icons, not column headings. Look under the visual’s General formatting controls for header or header-icons settings; the exact controls can depend on the visual and Power BI version.
Related
- Onshape Combine Parts Into One: Boolean Union Guide
- Excell Battery Company: What It Makes and Who It Serves
- Enum Values: Meaning, Examples, and How They Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Remove Duplicates Without Shifting Rows in PlaceYes—but not by using Excel’s Remove Duplicates command, which removes repeated records and compacts the selected data. To…
- Excel Merge Cells but Keep All Data?No—Excel cannot merge cells while retaining each cell’s value as separate data. When you merge a range, it…
- How to Alphabetize in Google SheetsTo alphabetize in Google Sheets, select the data you want to organize, then choose Data > Sort range…
- Excel List of Values Dropdown: 10 Reliable Ways to BuildIn Excel for Microsoft 365 on Windows, select the cells for the dropdown, choose Data > Data Validation,…
- Excel Center Louisville KY: What It Is & How It WorksThe Excel Center in Louisville, KY, is a free, public charter high school for adults (ages 21 and…
- Outlook Shared Mailbox Rules: How to Create ThemTo create rules for an Outlook organization mailbox, open the shared mailbox in Outlook on the web, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.