Hide Column in Tableau: Steps and Tips

To hide a column in Tableau, right-click the column header in the view and select Hide. This removes the selected column or member from the display without deleting its data; use Show Hidden Data to bring hidden members back when needed.

What Hiding a Column Means in Tableau

Tableau builds a view from fields, marks, headers, and axes, so a “column” can mean more than one thing. In a text table, it may be a column of values for one member of a dimension, such as a particular month. In another view, it might mean the header for a field placed on the Columns shelf. The right action depends on which of these you want to conceal.

When you hide a member from the view, Tableau stops displaying that member but does not delete the records from the data source. That distinction matters: hiding is a presentation choice, not a way to clean or permanently remove data. Hidden values can still affect calculations, including some table calculations, so a view that looks as though a value is absent may not calculate as if the underlying records were removed.

Hiding is useful for decluttering a crosstab, temporarily reducing the number of categories shown, or focusing a dashboard on a subset of visible marks. If your goal is to exclude records from the analysis, use a filter instead. If your goal is only to remove a field’s label or axis, hide its header rather than hiding its data.

Hide a Column or Column Member

In Tableau Desktop for Microsoft 365-era Windows installations, the usual method is to act directly on the header in the worksheet. The same basic view interaction is available in Tableau authoring on the web, though context-menu wording and available commands can vary slightly by product version and permissions.

Open the worksheet containing the table or chart.
Find the column header or member you want to hide. For example, in a table with a Month header, locate the specific month rather than the whole worksheet.
Right-click the header, or the corresponding mark if the view does not show a traditional table header.
Select Hide from the context menu.
Check the view to confirm that the intended member disappeared. If you hid a member used in a chart, its mark should no longer be displayed.

To hide several separate members, select the relevant headers or marks and use the context menu’s hide command. On Windows, Ctrl-click is commonly used to select multiple items; on Mac, use Command-click. Selection behavior can depend on the view type, so confirm that only the intended items are selected before choosing Hide. If the items are adjacent, dragging across them may select a range in some views.

If you do not see a Hide command, make sure you have right-clicked a value or mark in the view rather than an unrelated blank area. Also check whether you are editing the worksheet or merely interacting with a published dashboard. A dashboard may allow filtering and selection without exposing every worksheet authoring command.

Hide a Header Without Hiding the Values

Sometimes the numbers or marks should remain, but the header, field name, or axis is taking up space. In that case, toggle the header rather than hiding a data member. For a field on the Rows or Columns shelf, open the field pill’s menu and turn off Show Header. Depending on the view, you can also right-click the displayed header or axis and use the relevant header or axis option.

This changes how Tableau labels the view; it does not remove the field from the visualization. For example, turning off the header for a discrete Month field can leave the month-based columns in place while removing their labels. Hiding the member for March, by contrast, removes March from the visible view. These actions can look similar at first, but they have different effects on the layout and interpretation.

For a continuous field, Tableau generally displays an axis rather than a set of discrete column headers. Hiding the axis conceals its scale and labels while retaining the plotted marks. Before doing so, consider whether readers need the scale to interpret the values. If the scale is essential, a better option may be to format the axis or reduce its visual prominence rather than remove it.

Restore Hidden Data or a Hidden Field

If you hid a member from the view and later want to restore it, right-click in the worksheet and choose Show Hidden Data when that command is available. Tableau reveals hidden members so you can select the ones to show again. The precise selection steps can differ with the view: in a text table, inspect the relevant header area; in a chart, look for the hidden-data indicator or the restored member in the view.

There is another case: a field itself may have been hidden from the Data pane. This is different from hiding a column member in a worksheet. To restore a hidden field in Tableau Desktop, open the Data pane’s menu and enable Show Hidden Fields. Hidden fields appear in the pane with a muted appearance; right-click the field and choose Unhide. The field can then be used in the view again.

If the hidden-data command is not available, check that the view still contains the field or context needed to identify the hidden member. A filter may also be responsible for the item’s absence. Removing a filter or changing its selection is not the same as unhiding a member, so review the Filters shelf and any dashboard filter controls before assuming the data was hidden.

Hide, Filter, Exclude, or Remove: Which Should You Use?

These options can all make a column disappear, but they communicate different intentions and can affect calculations differently. Choose based on whether you are changing only the display, changing the data included in the analysis, or changing the structure of the worksheet.

Hide: Conceals selected members or marks from the view. The underlying records remain, and they may still contribute to calculations.
Filter: Limits which data is included in the view according to a condition or selected values. Filters are the more appropriate tool when excluded records should not contribute to the analysis.
Exclude: Removes selected marks from the view using a selection-based action. It is often a quick way to omit selected values, but check the resulting filter and calculation behavior if the analysis depends on the distinction.
Remove a field: Removes a pill from the Rows or Columns shelf, changing the view’s structure. It does not mean the source data has been deleted.
Hide a header: Keeps the field and its marks in the view while suppressing the header or axis display.

For example, imagine a sales crosstab with columns for January through December. If January is temporarily distracting but should remain part of a calculation, hiding it may fit the goal. If the question is specifically about sales from February through December and January must not count in the result, apply a filter. If the entire month field should no longer divide the view into columns, remove that field from the Columns shelf.

Common Problems and Checks

A frequent source of confusion is hiding a header when the intention was to hide a value. If the column labels disappear but the measures remain, you likely switched off Show Header. Re-enable it from the field pill or the header’s context menu. Conversely, if a whole category vanishes but you only wanted to remove its label, use the header option instead of Hide.

Another common issue is that a hidden item still influences a total or a calculation. That can happen because hiding does not necessarily remove its records from the computation. If the result must exclude those records, inspect the filters and the calculation’s definition. Table calculations can also depend on the direction and partitioning of the visible table, so hiding a member may affect what is displayed without producing the same result as filtering it out.

When a column does not appear to hide, verify that you selected the intended header or mark and that you are working in the worksheet where the view is built. In a dashboard, the displayed sheet may be controlled by a filter, action, or parameter. Editing the source worksheet may be necessary to change the view permanently. Also check whether the missing value is simply outside the current filter selection or absent from the data at the source.

Finally, remember that hiding an item is not a privacy or security measure. A hidden value can remain in the workbook’s data and may be recoverable by an author or through other views. Do not rely on Hide to protect confidential information; restrict access to the data or remove sensitive fields through the appropriate data-governance process.

Choosing a Good Approach for Tables and Dashboards

For a one-time exploratory worksheet, Hide is convenient because it is quick and reversible. For a published dashboard that other people will use, a filter control is usually clearer if viewers need to choose which values appear. A static hidden member can surprise users who do not know the worksheet was edited to omit it.

Consider documenting deliberate omissions in a worksheet title, caption, or explanatory note. For instance, a subtitle saying “Selected product categories shown” gives more context than leaving a category out without explanation. This is especially important when the display is used for reporting: viewers may assume a table is complete unless the view says otherwise.

Before publishing, check totals, labels, tooltips, and any dependent calculations after changing visibility. Test the dashboard using the controls that viewers will have, and verify that a hidden member is not being mistaken for a zero, a missing record, or a filter exclusion. A clean-looking view is useful only if its meaning remains clear.

Frequently Asked Questions

How do I hide one column in a Tableau crosstab?
Right-click the column header or the specific member’s header in the worksheet and choose Hide. If you want to hide the label but keep the values, use the field’s Show Header option instead.

How do I show a hidden column again in Tableau?
Right-click in the view and choose Show Hidden Data if the command is offered, then restore the relevant member. If you hid a field in the Data pane, enable Show Hidden Fields there and use Unhide on the field.

Does hiding a column remove its data from Tableau?
No. Hiding changes what is displayed; it does not delete source records. Hidden values can still affect calculations, so use a filter when records must be excluded from the analysis.

What is the difference between Hide and Show Header?
Hide conceals selected data members or marks from the view. Show Header controls whether Tableau displays the field’s header or axis. Turning off a header can leave the data and marks in the view.

Can I hide a column in a published Tableau dashboard?
You can interact with many published views, but the available commands depend on the site, permissions, and whether you have web-authoring access. For a lasting change, edit the underlying worksheet or use a filter control designed for dashboard viewers.

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.