Highlight tables in Tableau - Step-by-Step Guide

Introduction

Highlight tables help you see patterns by coloring table cells based on their values. This makes it easy to spot high or low numbers quickly in your data.

When you want to compare sales numbers across different regions and months in one view.

When you need to find the highest or lowest values in a large table of data.

When you want to visually emphasize differences in performance metrics like profit or revenue.

When you want to quickly spot trends or outliers in a detailed data table.

When presenting data to others who prefer visual cues over raw numbers.

Steps

Step 1: Open your Tableau workbook and go to the worksheet with your data table

- Tableau workspace

You see your data displayed in rows and columns

💡 Make sure your data is arranged in a table format with measures and dimensions

Step 2: Drag the measure you want to highlight (e.g., Sales) to the Color shelf

- Marks card

Table cells change color based on the measure values

💡 Use a continuous color palette for smooth shading

Step 3: Change the mark type to Square

- Marks card, Mark type dropdown

Cells become colored squares filling the table grid

💡 Squares fill the cell area better for highlight tables

Step 4: Drag the same measure to the Text shelf

- Marks card

Numbers appear on top of the colored squares

💡 This shows the exact values along with the color

Step 5: Adjust the color palette by clicking Color on the Marks card and selecting Edit Colors

- Marks card > Color > Edit Colors

You can choose colors that make differences clearer

💡 Use colorblind-friendly palettes if sharing with others

Before vs After

Before

Table shows sales numbers as plain text in rows and columns with no color

After

Table cells are colored with squares where darker colors show higher sales and numbers appear on top

Settings Reference

Mark type

📍 Marks card, Mark type dropdown

Changes how data points are visually represented; Square is best for highlight tables

Default: Automatic

Color palette

📍 Marks card > Color > Edit Colors

Controls the colors used to represent measure values

Default: Tableau default sequential palette

Measure on Color shelf

📍 Marks card > Color

Determines which values control the cell colors

Default: None

Measure on Text shelf

📍 Marks card > Text

Shows the numeric values on the colored cells

Default: None

Common Mistakes

Dragging a dimension to the Color shelf instead of a measure

Dimensions are categories and do not create meaningful color gradients for highlight tables

Always drag a numeric measure to the Color shelf to show value-based colors

Leaving the mark type as Automatic or Text

Text or Automatic marks do not fill the cell area well, making the highlight effect weak

Change the mark type to Square for full cell coloring

Summary

Highlight tables use color to show differences in numeric values across a table.

Drag a measure to Color and Text shelves and set mark type to Square for best effect.

Use appropriate color palettes to make patterns easy to see.