What is a Heat Map in Tableau?

A table full of numbers can feel like a solid wall of text - daunting, messy, and hard to interpret. Transforming that data into a heat map in Tableau, however, turns that wall into a revealing window, letting you instantly see the hot and cold spots in your data story. This guide will walk you through exactly what a heat map is, why it's so effective, and the step-by-step process to build two common types in Tableau.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Exactly Is a Heat Map?

At its core, a heat map is a data visualization technique that uses a spectrum of color intensity to represent values. Imagine a spreadsheet where instead of just reading numbers, you could immediately see the most important cells because they’re colored brightly, while less important ones fade into the background. That's the power of a heat map.

They excel at two things:

• Representing Magnitude: A darker shade of blue might represent higher sales figures, while a lighter shade shows lower sales. This allows your brain to process the information visually and pick up on patterns far faster than it could by comparing numerical values one by one.
• Representing Density: They can also show the concentration of data points in a given area. Think of a map showing customer locations - a heat map would highlight the “hotspots” where customers are most clustered.

In essence, heat maps make it simple to quickly scan large amounts of data and find clusters, outliers, and patterns that would otherwise be hidden. It’s a go-to choice for things like analyzing product sales by month, viewing website user clicks on a page, or understanding service call concentrations by region.

Why Use a Heat Map in Tableau?

Tableau is an incredibly powerful visualization tool, but why should you specifically choose a heat map from its long list of charting options? There are several great reasons.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Instantly Spot Patterns and Trends

The human brain is wired to process visual information, especially color, much more efficiently than it processes rows and columns of numbers. A heat map leverages this by transforming numbers into a color scale. You can immediately see which product category performed best in Q4 or which sales region is lagging behind without ever having to read a single number. This immediate feedback is invaluable for quick analysis and decision-making.

Visualize Concentration and Density

Sometimes the key insight isn’t about a single value but about the concentration of many values. Geographical heat maps in Tableau are perfect for this. If you’re a retailer wanting to know where to open your next store, a heat map showing the density of your online customers can give you a clear, data-driven answer. It moves beyond individual data points to show the bigger, collective picture.

Handle Large Datasets Gracefully

A table with ten thousand rows is practically unusable for manual analysis. It’s information overload. A heat map, however, can summarize that entire dataset into a single, cohesive visual. It scales beautifully, giving you a high-level overview that remains intuitive and interpretable, no matter how many data points are behind it.

Improve Stakeholder Communication

Heat maps are not only effective, they are also visually engaging and easy for non-technical audiences to understand. Presenting a spreadsheet during a meeting can cause eyes to glaze over. Showing a heat map that clearly highlights a trend or problem area makes your point instantly and memorably. It’s a powerful tool for telling a compelling data story.

Types of Heat Maps in Tableau

In Tableau, you can create a few variations of heat maps, but they primarily fall into two categories:

1. Grid Heat Maps: This is the classic, spreadsheet-style heat map consisting of colored rectangles arranged in a grid. Tableau often refers to a version of this as a “Highlight Table.” It’s ideal for comparing two different categories, like sales performance across different regions and time periods.
2. Geographical Heat Maps: Also known as density maps, these visualizations superimpose a heat map layer over a geographical map. They are exceptional for showing the concentration of events or occurrences in a physical space, such as customer locations or crime statistics.

Let's dive into how you can build both of these from the ground up.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

How to Create a Heat Map in Tableau: A Step-by-Step Guide

We’ll use the "Sample - Superstore" dataset that comes included with every copy of Tableau, so you can follow along easily.

Creating a Grid Heat Map (Highlight Table)

Our goal here is to create a grid that shows sales performance for different product sub-categories each month. Hot spots will show high sales, and cool spots will show low sales.

1. Step 1: Set Up Your Grid Structure First, you need to create the table that will become your heat map. Drag a dimension to the Columns shelf and another to the Rows shelf.

• Drag Order Date to the Columns shelf. Right-click it and make sure you select Month (the option with a calendar icon and the sample "May").
• Drag Sub-Category to the Rows shelf.

You should now see a grid with months across the top and product sub-categories down the side.

1. Step 2: Add Your Measure to Color This is where the magic starts. We need to tell Tableau what value should determine the color of each cell. In our case, it's sales.

• Find the Sales measure in your data pane and drag it directly onto the Color card in the Marks pane.

At this point, you'll see a table of numbers where the text itself is colored. We're close, but not quite there yet.

1. Step 3: Change the Mark Type to Square To turn the colored text into filled cells, you need to change the chart type (or "mark type" in Tableau-speak).

• In the Marks pane, click the dropdown menu that currently says Automatic and change it to Square.

Now, your view should transform into a beautiful heat map, with each cell colored based on its sales value.

1. Step 4: Customize the Colors (Optional) The default color palette is good, but you can tailor it to your needs.

• Click on the Color card, then select Edit Colors.
• From the Palette dropdown, you can select different color schemes. An 'Orange-Blue Diverging' palette is excellent for showing positive and negative values (like profit), while a sequential palette like 'Green' is great for values that only go up from zero (like sales).

1. Step 5: Add Numeric Labels (Optional) Sometimes you want both the visual color cue and the precise numerical value. This is how you create what Tableau calls a Highlight Table.

• Drag the Sales measure from the data pane again, but this time, drop it onto the Label card in the Marks pane.

The sales figure will now appear inside each square, giving you the best of both worlds: quick visual analysis and detailed numerical data.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Creating a Geographical Heat Map (Density Map)

Now, let's create a map showing the density of customers in the United States. High-density areas will show where we have the most customer activity.

1. Step 1: Build the Basic Map Tableau is smart enough to analyze geographic data. We just need to give it the right fields.

• Double-click the State dimension. Tableau will automatically generate latitude and longitude coordinates and plot each state on a map.

1. Step 2: Add a Level of Detail Right now, we just have one mark per state. To create a density map, we need to plot every individual data point. We can use a unique ID for each order to do this.

• Drag the Order ID dimension onto the Detail card in the Marks pane.

You’ll now see way more points on the map, likely overlapping in dense urban areas. This is the raw material for our heat map.

1. Step 3: Change the Mark Type to Density This is the key step. We simply tell Tableau to change its calculation from plotting individual points to plotting their concentration.

• In the Marks pane, click the dropdown that says Automatic and change it to Density.

Instantly, Tableau replaces the dots with a colorful heat map overlay, showing fiery "hotspots" where order density is highest and fading out to cooler colors where it is sparse.

1. Step 4: Adjust the Density and Color You can fine-tune the appearance to tell a clearer story.

• Click the Color card. From here, you can change the Intensity slider to make the hotspots bigger or smaller.
• You can also change the Color palette. There are specific palettes designed for density maps, like 'Temperature Diverging'.
• The Opacity slider can be useful if you want to see the underlying map more clearly through a semi-transparent heat map layer.

Final Thoughts

Heat maps are one of the most intuitive and effective ways to find and communicate patterns in Tableau. Whether you're analyzing performance in a grid or visualizing geographic concentration on a map, they transform overwhelming raw data into a clear, compelling story that anyone can understand at a glance.

Learning to build visualizations in powerful tools like Tableau is a fantastic skill, but it still involves multiple steps and a dedicated learning process. We created Graphed because we believe getting insights shouldn't require so much manual work. After connecting your data sources in just a few clicks, you can create real-time dashboards and reports simply by asking questions in plain English, like "Show me a chart of sales by product category for last quarter." It’s designed to deliver the insights you need in seconds, freeing you up to focus on strategy instead of report-building.