What is a Highlight Table in Tableau?

A highlight table is one of the quickest ways to turn a dense wall of numbers into a clear, actionable visual in Tableau. It adds an immediate layer of insight to a standard spreadsheet view, making hot spots and cold spots in your data jump right off the screen. This guide will walk you through exactly what a highlight table is, why it's so useful, and how you can create and customize one in just a few steps.

What Exactly Is a Highlight Table?

Think of a highlight table as a crosstab, or text table, supercharged with color. A standard text table shows you numbers in rows and columns - like a basic spreadsheet. It’s precise, but it forces you to manually scan and compare every single cell to find the highest or lowest values.

A highlight table solves this by adding a colored background to each cell. The color of the cell corresponds to the value of the number inside it. Typically, higher values get a darker or more saturated color, while lower values get a lighter shade. This simple addition creates a visual map of your data’s magnitude, directing your audience’s attention to the most important figures instantly.

It's the perfect middle ground between a plain text table and a heatmap.

• A Text Table gives you the precise numbers but offers no visual cues.
• A Heatmap gives you powerful visual cues with color blocks but often hides the numbers.
• A Highlight Table gives you the best of both worlds: the quick visual patterns of a heatmap and the numerical precision of a text table.

When Should You Use a Highlight Table?

Highlight tables are versatile and shine in situations where you need to compare values across two different categories. They excel at telling stories that would otherwise be buried in rows of data.

1. Pinpointing High and Low Performers Instantly

The primary use of a highlight table is to quickly spot outliers. Imagine you're looking at sales figures for different product categories across several regions. A standard table would require you to read dozens of numbers to figure out that “Phones” in the “West” region is your top performer.

With a highlight table, that cell would likely have the darkest shade, making it stand out immediately. This lets you and your stakeholders focus on the most significant data points without getting lost in the details.

Example: Analyzing monthly website traffic by channel. A dark green cell can instantly show you that Organic Search in November was your most successful combination, while a light green or red cell might highlight poor performance from a paid campaign in February.

2. Identifying Patterns Across Categories

Color gradients make patterns emerge that are nearly impossible to see in a grid of plain numbers. You can quickly see if a whole row or column is performing better or worse than others.

Example: A table showing customer satisfaction scores (CSAT) by support agent and issue type. You might notice that one agent (a row) has consistently lighter colors across all issue types, indicating a potential need for more training. Or you might see that one issue type (a column) has dark colors for every agent, suggesting a great product feature.

3. Presenting Data to a Mixed Audience

Dashboards often need to serve different types of stakeholders. Executives might want a high-level visual summary, while analysts may need to dig into the exact numbers. A highlight table caters to both.

The color provides the quick "at-a-glance" summary for those who want the main takeaway in seconds. The numbers provide the detailed proof for those who need to verify, report, and analyze the data more deeply. It’s an effective way to present data without having to create separate visuals for different audiences.

How to Build a Highlight Table in Tableau: A Step-by-Step Guide

Creating a highlight table is one of the most straightforward processes in Tableau. We’ll use the "Sample - Superstore" dataset that comes with every copy of Tableau so you can follow along easily.

Step 1: Create the Basic Text Table (Crosstab)

First, we need to build the structure of our table with dimensions and add a measure to show the values.

1. Open Tableau and connect to the "Sample - Superstore" dataset.
2. Drag the Sub-Category dimension from the Data pane onto the Rows shelf.
3. Drag the Region dimension from the Data pane onto the Columns shelf.
4. Drag the Sales measure onto the Text mark in the Marks card.

At this point, you'll have a standard text table. It shows the sales figures for each sub-category within each region, but it's just a grid of numbers.

Step 2: Add Color to the View

This is the magic step that transforms your text table into a highlight table.

1. Find the Sales measure in the Data pane again.
2. Drag Sales onto the Color mark in the Marks card.

Just like that, Tableau adds a color gradient to the background of each cell based on its sales value. By default, it uses a continuous blue gradient where higher sales figures have a darker blue and lower sales have a lighter blue. Your view is now a highlight table!

Alternative Method: Using the "Show Me" Menu

Tableau's "Show Me" feature makes this even faster. After you have at least one dimension on Rows/Columns and one measure in the view, you can use it to create the chart instantly.

1. With Sub-Category, Region, and Sales in your view (from Step 1), open the Show Me menu in the top-right corner.
2. Click on the Highlight Tables chart type. It’s the one that looks like a grid with colors and numbers.

Tableau will automatically rearrange the pills, change the mark type on the Marks card to Square, and place your measure on both the Color and Text marks for you.

Step 3: Customize Your Highlight Table

Now that you have the basic structure, you can refine it to better tell your story.

Editing the Colors

The default blue color scheme is fine, but you will often want to change it to match your company's branding or to better reflect the data.

1. In the Marks card, click on the Color shelf.
2. In the menu that appears, click Edit Colors...
3. From the Palette dropdown menu, you can choose a different color scheme. The Orange-Blue Diverging palette is excellent for measures like Profit, where you can center the color on zero. This clearly separates positive values (blue) from negative values (orange).
4. You can check Stepped Color to group values into distinct color bins instead of using a smooth gradient, which can sometimes make comparisons easier.
5. Click OK to apply your changes.

Formatting Numbers

If your numbers represent currency or percentages, you should format them accordingly.

1. In the data pane, find your measure (e.g., Sales).
2. Right-click on it and go to Default Properties > Number Format...
3. Choose Currency (Standard) or another appropriate format.

This will update the number formatting everywhere you use that measure, making your tables clean and professional.

Final Thoughts

Highlight tables are a simple yet powerful visualization in Tableau. They perfectly balance the need for high-level visual patterns with the demand for granular, numerical detail, making them an essential chart type for any analyst's toolkit. By adding a layer of color to a simple crosstab, you can instantly draw attention to key business insights that would otherwise take minutes of scanning to find.

While tools like Tableau make visualizations accessible, we know there’s still a learning curve and time commitment involved in connecting data and building reports. That's why we created Graphed. We automate the entire process by allowing you to connect your data sources - like Google Analytics, Shopify, or Salesforce - and build real-time dashboards just by asking in plain English. Instead of dragging and dropping fields, you could simply ask, "create a highlight table of sales by sub-category and region," and get your live dashboard in seconds, not hours.