How to Hide Measure Column in Tableau

Hiding a column in Tableau is a simple skill that can dramatically improve your reports and dashboards. You often need measures to drive calculations, sorting, or colors behind the scenes without needing them visually displayed in a table or on an axis. This tutorial will walk you through the most common methods for hiding measure columns to create cleaner, more focused, and user-friendly visualizations.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Would You Hide a Measure in Tableau?

Before diving into the "how," let's quickly cover the "why." Hiding a measure isn't about concealing data, it's about strategic presentation. Most often, you'll hide a measure to:

• Improve Clarity in Tables: You might create a text table (or crosstab) and need to sort your rows by a specific metric, like profit, but you only want to display the sales column. Hiding the profit column keeps the table tidy while preserving the logical order.
• Create Advanced Visualizations: Many advanced chart types rely on measures to position marks on the canvas without needing an axis. For an advanced chart, you use a calculated field to create the structure but don't want the underlying numbers cluttering the view.
• Enhance Dashboard Design: On a dashboard, you may want to show a visualization without its axis (header) because the chart title or a dynamic KPI card already provides that context. Hiding the header gives you more design flexibility and saves valuable space.
• Control Tooltips: A measure might be necessary for a calculation or filter, placing it on the Detail shelf. By default, Tableau adds it to the tooltip. You can hide it to prevent showing users intermediate or confusing data points when they hover.

At its core, hiding measures is a fundamental technique for moving from a functional worksheet to a polished, professional report.

Method 1: Hide a Column from a Text Table for Sorting or Filtering

This is one of the most common scenarios. Imagine you have a table showing sales data for different product sub-categories, and you want to order the list from most profitable to least profitable without actually showing the profit column.

The trick is to move the measure you want to hide from the main view onto the Detail shelf on the Marks Card. This makes the data available for underlying functions like sorting but removes it from the table structure.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions:

1. Build a Basic Text Table: Drag a dimension like Sub-Category to the Rows shelf. Then, drag SUM(Sales) to the Text shelf on the Marks Card. You now have a simple list of sub-categories and their corresponding sales.
2. Add the Sorting Measure to Detail: Find the measure you want to sort by - in this case, Profit. Instead of placing it on Rows or Columns, drag SUM(Profit) directly onto the Detail shelf in the Marks Card.

Notice that nothing visually changes in your table yet. The profit data is now associated with each sub-category mark, but it's not being displayed.

1. Apply the Sort: Right-click the Sub-Category pill on your Rows shelf and select Sort.
2. Configure the Sort Settings: In the sort dialog box, make the following changes:

Close the sort menu, and you’re done! Your table is now sorted by profit, but the profit column is nowhere to be seen, leaving you with a clean, perfectly ordered sales report.

Method 2: Hide a Measure's Header or Axis on a Chart

Sometimes you need the measure to build your visualization - like a series of bars or a line - but you don't need the axis it creates. Hiding an axis, which Tableau calls a "header," is perfect for minimalist dashboard designs or when a chart’s title already explains what the values represent.

This is probably the easiest way to hide a measure in Tableau, as it takes just a couple of clicks.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step-by-Step Instructions:

1. Create Your Chart: Build a simple bar chart by dragging a dimension, like Region, to the Columns shelf and a measure, like SUM(Sales), to the Rows shelf. You will see a vertical axis on the left showing the sales values.
2. Hide the Header: Locate the green SUM(Sales) pill on the Rows shelf. Right-click on it.
3. Uncheck "Show Header": In the context menu that appears, simply uncheck the option for Show Header.

The vertical sales axis will instantly disappear. The bars remain, correctly scaled according to their sales value, but the visual clutter of the axis is gone. You can do the same for measures on the Columns shelf to hide horizontal headers.

Expert Tip: To bring the header back, just right-click the SUM(Sales) pill again and re-check Show Header.

Method 3: Remove a Hidden Measure from a Tooltip

When you use Method 1 and place a measure onto the Detail shelf, Tableau automatically adds it to the tooltip. This can sometimes defeat the purpose of hiding it, as users will see the figure when they hover over a mark.

Cleaning up your tooltip is a critical final polish for any dashboard.

Step-by-Step Instructions:

1. Use a View with a Measure on Detail: Start with the sorted text table we created in Method 1, where SUM(Profit) is on the Detail shelf. Hover over one of the sub-category rows, and you will see the tooltip showing both Sales and Profit.
2. Open the Tooltip Editor: In the Marks Card, click on the Tooltip shelf. This will open an editor window where you can customize the text and fields that appear on hover.
3. Remove the Unwanted Measure: Inside the editor, you'll see lines of text like Sub-Category: <Sub-Category> and Profit: <SUM(Profit)>. Simply highlight the entire line for the measure you want to hide (including its label) and delete it.
4. Click OK to Save: After deleting the line, click the OK button.

Now, when you hover over a mark, the tooltip will only show the information you want to share. This gives you complete control over the user experience.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Practical Example: Coloring a Bar Chart with a Hidden Measure

Let's tie these concepts together with a practical use case. You want to create a bar chart showing Sales per Category, but you want to color the bars by their Profit Ratio to quickly spot which categories are most efficient with their sales.

1. Create the Bar Chart: Drag Category to Columns and SUM(Sales) to Rows.
2. Create the Profit Ratio Calculation: Right-click in the data pane (on the left side), select Create Calculated Field. Name it "Profit Ratio" and enter the formula:

SUM([Profit]) / SUM([Sales])

Click OK. Then, change its default formatting to a percentage by right-clicking the new field > Default Properties > Number Format > Percentage.

1. Use the New Measure for Color: Drag your newly created Profit Ratio measure directly onto the Color shelf in the Marks Card.
2. The Measure is Now Hidden by Default: Your bars are now colored based on their profitability, with a color legend explaining the scale. Notice that the Profit Ratio value is not displayed on an axis or in a column - it's driving the visualization without being explicitly shown. You’ve successfully used a measure while keeping it "hidden" from the main chart canvas.
3. Final Polish (Optional): Hover over a bar. Tableau has added Profit Ratio to the tooltip. If you'd rather not show it, use the steps from Method 3: click the Tooltip shelf and delete the AGG(Profit Ratio) line to tidy it up.

You now have an insightful, clean, and professional chart that communicates two metrics (Sales and Profit Ratio) in a single, intuitive view.

Final Thoughts

These methods - using the Detail shelf for calculations, unchecking "Show Header" to remove an axis, and editing the tooltip for clarity - are essential skills for any Tableau user. They give you the control to build visualizations that are not only accurate but also intentionally designed to guide your audience's focus toward the most important insights.

Learning how to manipulate pills and shelves in tools like Tableau is a powerful skill, but it often requires hours of practice to master. As we work on Graphed, we aim to eliminate this complexity. Instead of manually building a view and then taking extra steps to hide sorting columns or clean up a tooltip, you can just describe the final outcome you want. Simply asking, "Show me sales by category sorted by profit" instantly gives you the clean, final table you need, saving you the steps in between.