Tableau Course
Highlight Tables
A highlight table is a crosstab where every cell contains an exact number and the cell's background colour encodes the same value — giving readers both the precision of a table and the pattern-recognition power of colour in a single view.
Highlight Tables — Numbers and Colour Together
A plain text table is precise but slow to read — your eye has to scan every number to find the highs and lows. A heat map is fast to scan but sacrifices exact values — you see the pattern but not the number. A highlight table resolves this trade-off by combining both: the number sits in the centre of each cell, and the cell's background shading encodes that same number as colour intensity. The result serves analysts who need precision and executives who need pattern recognition in the same single view.
Building a Highlight Table — Step by Step
Highlight Table — Labelled Mockup
Adjusting Label Colour for Readability
Dark cells need white labels. Light cells need dark labels. Tableau does not do this automatically — by default all labels share one colour setting. To fix this, click the Label channel on the Marks card → Font → set to white. Then right-click any dark cell → Format → adjust the font colour for the specific pane. A more reliable technique is to use a calculated field for the label colour: if the Sales value is above a midpoint threshold, set the label to white; below the midpoint, set it to a dark navy. This ensures every label is legible regardless of the cell's shade.
Adding a Grand Total Row and Column
A highlight table becomes more useful when totals are added. Go to Analysis menu → Totals → Show Row Grand Totals and Show Column Grand Totals. Tableau adds a totals row at the bottom and a totals column on the right. The total cells are shaded by the same colour scale — the overall column totals immediately reveal which Region drives the most Sales, and the row totals reveal which Sub-Category is the largest overall.
Table Calculations Inside Highlight Tables
The most powerful version of a highlight table uses a table calculation for the colour — such as Percent of Total — while showing the raw number as the label. This lets the reader see both the absolute value and how each cell compares to its row, column, or overall total simultaneously.
To apply this, right-click the Measure on the Color channel → Add Table Calculation → select Percent of Total and set the compute direction (Table Across, Table Down, or Table). The label still shows the raw Sales number while the colour shading now reflects relative share.
Highlight Table vs Heat Map — The Key Distinction
| Aspect | Highlight Table | Heat Map |
|---|---|---|
| Primary signal | The number — colour is a guide | The colour — numbers are optional |
| Audience | Analysts who need exact values with pattern guidance | Executives who need instant pattern recognition |
| Label | Always present — the number is essential | Optional — colour carries the message alone |
| Best palette | Sequential (one colour, light to dark) for a single measure | Diverging (two colours, centred at zero) for positive/negative measures |
The highlight table is the most dashboard-friendly chart in Tableau because it replaces the plain number table that most business users default to — while making the same numbers dramatically faster to read. If a stakeholder asks you to "just show me a table of the numbers," build a highlight table instead of a text table. The numbers are identical. The colour takes ten seconds to configure. And the result is a table that communicates in two modes simultaneously — precise for the analyst who wants to export the data, scannable for the executive who has thirty seconds. The Percent of Total table calculation on the colour channel is worth learning early: it turns a table of raw Sales figures into a market share matrix where the dominant cells darken automatically, even as the underlying numbers change with filters.
Practice Questions
1. After setting the mark type to Square on a Region × Sub-Category grid, which two channels on the Marks card need Sales to complete a highlight table?
2. A highlight table needs a grand total row at the bottom and a grand total column on the right. How do you add both?
3. A highlight table shows raw Sales as labels. You want the colour to reflect each cell's share of the grand total instead of the raw value. What do you do?
Quiz
1. An analyst needs a view showing exact Sales figures by Sub-Category and Region but also wants to spot the highest and lowest cells at a glance without scanning every number. Which chart type is the best fit?
2. A highlight table encodes Sales — a measure that is always positive — on the Color channel. Which palette type is most appropriate?
3. A colleague built a heat map but says the numbers are hard to read without labels. A highlight table is suggested instead. What is the fundamental difference between the two chart types that makes the highlight table better suited here?
Next up — Lesson 27: Dual axis charts — combining two chart types on a shared view to tell a richer story with two measures at once.