How to Show Headers in Tableau

Nothing is more frustrating than building a visualization in Tableau only to see a number-filled axis where you expected clear, descriptive headers. When your headers disappear, your entire chart or table can become meaningless. This guide will walk you through exactly how to show headers in Tableau, from the simple toggle switch to fixing the common issues that cause them to vanish in the first place.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Simplest Fix: Using "Show Header"

In many cases, showing a missing header is just a click away. Tableau gives you a direct option to toggle the visibility of headers for each field (or "pill") you place on your Rows and Columns shelves.

If you've placed a dimension like Category or Region onto your Columns shelf but don't see the text labels for each category, chances are the header has been turned off. Here is how you can easily fix that.

How to Show a Header for a Pill

Follow these steps to bring your missing header back:

1. Locate the blue or green pill on your Rows or Columns shelf that is missing its header in the view.
2. Right-click (or Command-click on a Mac) on that specific pill.
3. In the context menu that appears, look for the "Show Header" option. It will have a checkmark next to it if it's currently visible.
4. If there is no checkmark, simply click on "Show Header" to re-enable it. Your headers should immediately reappear in your visualization.

This is the go-to solution for headers that were either turned off by mistake or hidden by a previous setting. If this doesn’t work, don't worry - the issue likely lies with how Tableau is interpreting your data, and we'll cover that next.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Headers Disappear: The Difference Between Discrete and Continuous Fields

If the "Show Header" option is checked (or doesn't solve your problem), the real issue is probably tied to a core concept in Tableau: the difference between Discrete and Continuous fields. Understanding this is essential for controlling your visualizations.

You can quickly tell them apart on your shelves:

• Discrete Pills are Blue: Think of discrete fields as separate, distinct categories or "buckets." When you place a blue pill on a shelf, Tableau creates a header for each unique item in that field (e.g., "Technology," "Office Supplies," "Furniture").
• Continuous Pills are Green: Think of continuous fields as points along an unbroken range or a "measuring tape." When you place a green pill on a shelf, Tableau creates a quantitative axis (e.g., a scale from $0 to $100,000 in sales, or a timeline from January to December).

The number one reason a user sees an axis instead of headers is because the field has been set to Continuous when they need it to be Discrete.

Example: Dates and Numbers

This happens most frequently with dates and numerical IDs.

Dates: By default, if you drag your Order Date field to the Columns shelf, Tableau might display it as YEAR(Order Date) with a green pill. This creates an axis showing a continuous range of years (e.g., a timeline from 2020 to 2024). But what if you wanted separate headers for each individual year? You need to switch the field to discrete.

To fix this:

1. Right-click the green date pill on the Rows or Columns shelf.
2. In the menu, go to the second section and select the discrete option for Year (it will also show the date part, e.g., "Year 2024"). The pill will turn blue.
3. Instantly, your continuous axis will be replaced with distinct headers for each year ("2020", "2021", "2022", etc.) present in your data.

Numbers: This also applies to numbers you want to treat as categories, like a Product ID or Order ID. Tableau might automatically treat them as a continuous measure and try to sum them up or plot them on an axis. To fix this, simply right-click the green pill and select "Convert to Discrete". The pill will turn blue and create headers for each ID.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Working with Multiple Measures: Measure Names and Values

What if you want to show a simple table comparing several different measures side-by-side, each with its own header? For example, you want one table to show columns for Sales, Profit, and Quantity.

Trying to drag these individual measure pills to the Columns shelf one by one won't work as you expect, Tableau will try to create separate charts for each one. The solution is to use Tableau's special generated fields: Measure Names and Measure Values.

• Measure Values: A special field that contains the values of all the measures in your data pane.
• Measure Names: A special field that contains the names of all the measures in your data pane. You use this to create the headers.

How to Create Headers for Multiple Measures:

1. Drag the Measure Names pill from the Data Pane onto the Columns shelf. You will now see headers for every single measure in your dataset.
2. Drag the Measure Values pill from the Data Pane onto the Text button on the Marks card. This will populate your view with the actual numbers for each measure.
3. You probably don’t want to see every measure, so you'll see a new card appear called "Measure Names" in the Filters shelf. Drag any measures you don't want in your table out of this card. This allows you to select only the headers you want to display, like Sales, Profit, and Quantity.

By using Measure Names on your Columns shelf, you're explicitly telling Tableau to create a distinct header for each measure - a powerful way to build summary tables and KPI dashboards.

Customizing Your Headers

Once your headers are visible, your next step is to make sure they are clear, organized, and properly formatted for your audience. Tableau offers several options for this.

Renaming Headers with Aliases

Sometimes the field name in your database isn't very user-friendly - for example, it might be named cust_seg_all_caps. You can easily rename the header in your view without changing the underlying data field.

1. Right-click on one of the header labels directly in your visualization (e.g., the label "Technology" under the Category field).
2. Select "Edit Alias...".
3. A dialog box will appear. Type in your desired new name for that specific member and click OK. To alias the name of the main field itself (e.g., to change "Category" to "Product Category"), right-click on the pill in the Rows/Columns shelf, and select 'Edit in Shelf'.

Formatting Header Appearance

You can control the font, size, color, and alignment of your headers to match your dashboard's design.

1. Go to the main menu and click Format > Font.... This will open the Format Font pane on the left.
2. In this pane, you can select whether to format Rows or Columns.
3. Under the Header section, you can adjust the font, style, size, color, and alignment for all headers in your sheet.
4. For background colors, go to Format > Shading... and make adjustments in the Header section of the pane.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Sorting Data Using Headers

Sorting your data helps your audience quickly find the highest and lowest values. Tableau provides a few simple and familiar sorting icons that appear when you hover your mouse over a header.

• Hover over a dimension header to sort alphabetically (A-Z or Z-A).
• Hover over a quantitative axis header to sort your categories based on their values (ascending or descending). This quickly answers questions like "Which state has the highest sales?"

You can also access more advanced sorting options by right-clicking the corresponding discrete (blue) pill and selecting "Sort," which lets you define the sort logic based on another field, manually, or other criteria.

Final Thoughts

Getting your headers to appear correctly in Tableau often comes down to understanding the difference between discrete (blue pills that create labels) and continuous (green pills that create axes). Once you master that distinction, you’ll have complete control over whether Tableau shows headers or a quantitative axis in your beautiful designs.

Let's be honest, learning the specific logic of dashboarding tools, like when to use a discrete date part versus a continuous date value, takes time away from actual analysis. At Graphed, we felt this pain, so we made it possible to create dashboards simply by describing what you want to see. Instead of clicking through menus to turn axes into headers, you can just ask, "Show me sales by product category instead," and the visualization updates instantly - letting you focus on insights, not on figuring out the software.