Creating Highlight Tables in Tableau – Detailed Notes

Course: JustAcademy Tableau Training

Course Demo: Register for a Tableau Course Demo

1. Introduction to Highlight Tables

A Highlight Table is a data visualization in Tableau that combines the structure of a text table with color-based visual indicators. It displays data in rows and columns while using different colors or color intensities to highlight high, low, positive, negative, or otherwise important values.

Highlight tables help users identify patterns and compare values without having to examine every number individually. They are particularly useful when a business report contains several categories, regions, products, departments, or time periods.

For example, a sales manager may want to compare the profitability of different product sub-categories across multiple regions. A highlight table can display the profit values in a grid, using one color for lower or negative profits and another for higher profits.

In Tableau, a highlight table is generally created by placing dimensions on Rows and Columns, selecting Square as the mark type, and placing a measure on Color. A measure can also be placed on Text to display the exact numerical values inside the cells.

2. Learning Objectives

• Understand the meaning and purpose of highlight tables.
• Learn the difference between a highlight table and a heat map.
• Understand dimensions, measures, color encoding, and text labels.
• Create a highlight table using Tableau's Show Me feature.
• Create a highlight table manually using the Marks card.
• Customize colors, cell borders, labels, and tooltips.
• Use sequential and diverging color palettes appropriately.
• Analyze business performance across categories and time periods.
• Build an interactive highlight table for a dashboard.

3. Important Components of a Highlight Table

3.1 Rows

Rows display the categories or groups that you want to analyze vertically. Examples include Region, Product Category, Sub-Category, Department, Customer Segment, and Employee Name.

3.2 Columns

Columns display the categories or groups horizontally. Examples include Year, Month, Region, Product Category, or Customer Segment.

3.3 Measures

Measures are numerical fields that provide the values being analyzed. Common examples include Sales, Profit, Quantity, Discount, Revenue, Cost, and Number of Orders.

3.4 Color

Color communicates the relative magnitude or direction of a measure. Darker or more intense colors may represent larger values, while lighter colors may represent smaller values. The exact meaning depends on the selected palette and legend.

3.5 Text Labels

Text labels display the actual numerical values inside the cells. They allow users to combine precise figures with color-based visual interpretation.

3.6 Color Legend

The color legend explains how colors correspond to the measure's values. A clear legend is essential because viewers need to understand which colors represent high, low, positive, or negative values.

4. How a Highlight Table Works

A highlight table organizes data into a grid and applies a color to each cell according to a measure. Each cell represents the aggregated value for a particular combination of row and column categories.

1. Choose dimensions: Select the categories to display on Rows and Columns.
2. Select a measure: Choose the numerical value to analyze, such as Sales or Profit.
3. Build the grid: Tableau creates cells for the combinations of dimensions.
4. Apply color: Place the measure on Color in the Marks card.
5. Display values: Place the measure on Text if exact numbers should appear in each cell.
6. Interpret patterns: Use the color intensity and numerical labels to compare values.

Example Highlight Table

The values above are illustrative. In Tableau, each cell can be shaded according to its sales value. A suitable sequential palette could make lower values lighter and higher values darker, helping the viewer identify strong and weak areas quickly.

5. Highlight Table vs. Heat Map

Highlight tables and heat maps are related visualizations, but they are not identical.

Remember: A highlight table emphasizes a tabular view using color. A heat map can extend this idea by using both color and size to encode measures.

6. Requirements for Creating Highlight Tables

• A Tableau workbook connected to a data source.
• At least one dimension for grouping the data.
• A numerical measure to determine the cell colors.
• Optionally, a second dimension to create a more informative row-and-column grid.
• Optionally, a measure on Text to display exact numerical values.

Datasets such as Sample - Superstore are useful for practice because they include dimensions like Region, Category, Sub-Category, and Segment, along with measures such as Sales and Profit.

7. Method 1: Create a Highlight Table Using Show Me

Tableau's Show Me panel provides a quick way to create a highlight table from selected fields.

Step-by-Step Instructions

1. Open Tableau Desktop.
2. Connect to a dataset, such as Sample - Superstore.
3. Open a new worksheet.
4. Select the dimension fields you want to compare, such as Region and Category.
5. Select the numerical measure you want to analyze, such as Profit or Sales.
6. Open the Show Me panel.
7. Select Highlight Table.
8. Review the resulting grid and the color legend.
9. If needed, place the numerical measure on Text to show exact values in the cells.
10. Rename the worksheet to something meaningful, such as Profit Highlight Table.

Expected Result

Tableau displays a grid in which the rows and columns represent the selected dimensions. The cells use color to indicate the measure values, making it easier to locate high and low values.

The exact field arrangement and mark configuration may vary depending on the Tableau version and the fields selected.

8. Method 2: Create a Highlight Table Manually

Creating a highlight table manually provides more control over the layout, measure, color, labels, and cell formatting.

Step 1: Add a Dimension to Columns

Drag a dimension such as Segment to the Columns shelf. Tableau creates column headers based on the available members of the dimension.

Step 2: Add Dimensions to Rows

Drag Region to Rows. You can also add another dimension, such as Sub-Category, to create a nested table.

For example, Region can be placed on Rows first, followed by Sub-Category. This creates a hierarchy in which sub-categories are organized within regions.

Step 3: Select the Square Mark Type

On the Marks card, open the mark type drop-down and select Square. This creates square marks suitable for a highlight table.

Step 4: Place a Measure on Color

Drag Profit or Sales to Color on the Marks card. Tableau assigns colors according to the measure values.

Step 5: Place a Measure on Text

Drag the measure to Text on the Marks card if you want to display the exact value in each cell. If you want the table to emphasize patterns without displaying all numbers, you may choose to omit labels.

Step 6: Adjust Cell Size

Click Size on the Marks card and adjust the slider so that the squares fill the available cells appropriately. In a conventional highlight table, cells should be sufficiently large to make color differences visible and labels readable.

Step 7: Format and Review

• Choose a meaningful color palette.
• Add clear cell borders if needed.
• Format the measure as currency, a percentage, or a whole number.
• Check the color legend and axis headers.
• Rename the worksheet.

9. Understanding the Marks Card

The Marks card controls how Tableau displays marks in the visualization. For highlight tables, the most important settings are Color, Size, Text, Detail, and Tooltip.

10. Choosing the Right Color Palette

Color is one of the most important elements of a highlight table. The palette should match the meaning of the measure and help viewers interpret the data accurately.

10.1 Sequential Color Palette

A sequential palette uses different intensities of a color, or a progression between related colors, to represent values from low to high.

Example: Use a light-to-dark blue palette to display Sales, where lighter cells represent lower values and darker cells represent higher values.

Best used for: Measures where higher and lower values form a natural ordered range, such as Sales, Revenue, Quantity, or Number of Orders.

10.2 Diverging Color Palette

A diverging palette uses two contrasting color directions around a meaningful midpoint or threshold. It is particularly useful when the measure includes both positive and negative values.

Example: Use a red-to-blue palette for Profit, where negative profit is represented by one side of the palette and positive profit by the other.

Best used for: Profit and loss, variance from a target, percentage change around zero, or differences from a meaningful benchmark.

10.3 Stepped Color Palette

A stepped palette groups values into a limited number of color bands rather than assigning a smooth progression to every value.

Example: Classify sales into low, medium, and high bands.

Best used for: Reports that require clear value categories rather than subtle color differences.

Color Selection Best Practices

• Choose colors that communicate the meaning of the data.
• Use a sequential palette for a simple low-to-high progression.
• Use a diverging palette when a meaningful midpoint or threshold exists.
• Avoid using a diverging palette without a meaningful center.
• Make sure the color differences are easy to distinguish.
• Use the same color meaning consistently across related views.
• Keep the legend visible when viewers need to interpret the color scale.
• Consider color accessibility and do not rely on color alone to communicate essential information.

11. How to Change the Color Palette

1. Build the highlight table and place the measure on Color.
2. Locate the color legend in the worksheet.
3. Open the legend's drop-down menu.
4. Select Edit Colors.
5. Choose an appropriate palette from the available options.
6. If applicable, configure the center, range, or full color range settings.
7. Click Apply or OK to update the visualization.
8. Review the legend to ensure that the colors accurately represent the values.

For measures such as Profit, consider whether zero is an important dividing point. For measures such as Sales, a sequential palette is often easier to interpret.

12. Displaying Numerical Values Inside Cells

Highlight tables can combine colored cells with exact numerical values. This is useful when viewers need both a visual comparison and precise figures.

Steps

1. Locate the Marks card.
2. Drag the desired measure, such as Sales or Profit, to Text.
3. Click Text or Label to open the formatting options.
4. Adjust font size, alignment, and label settings where available.
5. Format the measure using a suitable number format.
6. Verify that the values fit inside the cells without overlapping.

Example: A cell might display ₹85,000 and use a dark color to show that the value is relatively high within the selected scale.

If the table contains many cells, labels may become crowded. In that case, retain color encoding and show exact values through tooltips instead.

13. Formatting Cell Borders and Size

13.1 Adding Cell Borders

Cell borders help distinguish adjacent squares, particularly when the colors are similar. On the Marks card, click Color and use the Border option if it is available for the selected mark type.

13.2 Adjusting Square Size

Click Size on the Marks card and move the slider to increase or decrease the size of the squares. Choose a size that makes the cells easy to distinguish while leaving enough room for the labels.

13.3 Formatting Headers

Use concise row and column labels. If dimension names are long, adjust the column widths or rename headers where appropriate.

13.4 Formatting Numerical Values

Use currency formatting for financial measures, percentage formatting for rates, and integer formatting for counts. Consistent number formats make the table easier to compare.

14. Practical Example: Profit by Region and Product Sub-Category

Business scenario: A retail company wants to understand which product sub-categories perform well or poorly across its sales regions. The analyst uses a highlight table to compare Profit by Region and Sub-Category.

Fields Required

Step-by-Step Process

1. Connect Tableau to Sample - Superstore.
2. Open a new worksheet.
3. Drag Region to Rows.
4. Drag Sub-Category to Rows, placing it beside Region to create a nested row structure.
5. Drag Segment to Columns.
6. Change the mark type to Square.
7. Drag Profit to Color.
8. Drag Profit to Text if you want exact values displayed in the cells.
9. Choose a diverging palette if you want to distinguish positive and negative profit.
10. Format the cell borders and labels.
11. Rename the worksheet to Profit by Region and Sub-Category.

Questions to Explore

• Which sub-categories have relatively high profit in each region?
• Which cells indicate low or negative profit?
• Do certain product groups perform differently across regions?
• Are there patterns shared by multiple customer segments?
• Would a filter or additional worksheet help investigate an unusual value?

The answers should be based on the actual values in your dataset. The color scale makes patterns easier to locate, but the exact numerical values and underlying business context should be checked before drawing conclusions.

15. Practical Example: Monthly Sales Performance

Business scenario: A sales manager wants to compare sales across months and product categories to identify strong and weak periods.

Suggested Fields

• Month: Display on Columns.
• Product Category: Display on Rows.
• Sales: Place on Color and optionally Text.
• Year: Use as a filter or additional dimension when comparing multiple years.

Steps

1. Connect to a dataset containing sales dates and sales values.
2. Place Month on Columns and Product Category on Rows.
3. Place Sales on Color.
4. Place Sales on Text if the precise monthly values are required.
5. Choose a sequential palette for low-to-high sales comparisons.
6. Add a Year filter if the dataset contains multiple years.
7. Review the table to identify recurring high- and low-sales periods.

Business benefit: A monthly highlight table can reveal seasonality, unusual declines, and category-level differences. However, comparisons should use consistent date ranges and appropriate aggregation.

16. Creating a Highlight Table with Multiple Measures

Sometimes a business report needs to compare more than one measure, such as Sales and Profit. Tableau allows multiple measures to be incorporated into a view, but the design should make each measure's meaning clear.

Example: Sales and Profit

• Use Region and Category to structure the table.
• Display Sales and Profit as separate measures in the view.
• Use appropriate formatting and color legends for the measures.
• Keep the color meaning consistent within each measure.
• Consider separate worksheets or side-by-side sections if using the same palette for both measures could confuse readers.

Important: Sales and Profit may have very different numeric ranges. Do not assume that the same color intensity means the same absolute amount across both measures unless the scales have been deliberately standardized and clearly explained.

17. Adding Filters to a Highlight Table

Filters help viewers focus on a selected part of the data without rebuilding the visualization.

Steps to Add a Filter

1. Drag a dimension such as Region, Segment, Category, or Year to the Filters shelf.
2. Choose the members or range you want to include.
3. Right-click the field on the Filters shelf and select Show Filter when that option is available.
4. Position and format the filter card.
5. Test the filter to make sure the table updates as expected.

Useful filters include Region, Customer Segment, Product Category, Order Date, and Year. Choose filters that support the business questions rather than adding every available field.

18. Tooltips and Interactive Analysis

Tooltips provide additional information when users hover over a cell. They are particularly useful when the highlight table is too dense to display every numerical detail directly.

Useful Tooltip Fields

• Row and column category names.
• Sales, Profit, or another measure.
• Number of orders or records.
• Relevant date or period.
• Additional fields that help explain unusual results.

How to Customize Tooltips

1. Open the Marks card.
2. Click Tooltip.
3. Edit the text to include the desired fields.
4. Use concise labels and readable formatting.
5. Test the tooltip by hovering over several cells.

For dashboards, highlight actions can also help viewers focus on related marks across views. These actions are different from the color encoding used to create the highlight table itself.

19. Highlight Tables in Tableau Dashboards

A highlight table can be added to a dashboard to support detailed comparisons alongside summary charts and key performance indicators.

Steps to Add a Highlight Table to a Dashboard

1. Create and format the highlight table worksheet.
2. Click New Dashboard.
3. Drag the highlight table worksheet onto the dashboard canvas.
4. Adjust the size so the row and column labels remain readable.
5. Add relevant filters, legends, or supporting charts.
6. Configure dashboard filter or highlight actions if they improve exploration.
7. Test the dashboard at different sizes.

Dashboard Design Tips

• Give the dashboard a clear title.
• Place the most important information where users can find it easily.
• Keep legends close to the corresponding table.
• Use consistent colors across related visualizations.
• Avoid overcrowding the dashboard with too many cells or filters.
• Make sure text labels and tooltips are readable.

20. Highlight Table vs. Crosstab

21. Common Mistakes and Troubleshooting

22. Best Practices for Creating Highlight Tables

• Choose dimensions that answer a specific business question.
• Use a measure that is meaningful for the intended comparison.
• Keep the color scale consistent and easy to interpret.
• Use sequential palettes for low-to-high comparisons and diverging palettes for meaningful positive/negative or above/below-threshold comparisons.
• Display numerical labels when exact values matter and the grid is readable.
• Use tooltips when labels would make the table overcrowded.
• Add cell borders when they improve the separation of marks.
• Format numbers consistently, especially when comparing currencies, percentages, or counts.
• Avoid excessive colors that distract from the data.
• Include a clear color legend.
• Use filters to simplify large tables.
• Check the aggregation and ensure that the data is summarized correctly.
• Test the table in the dashboard where it will actually be viewed.

23. Practice Exercises

Exercise 1: Profit by Region

Create a highlight table with Region on Rows, Category on Columns, and Profit on Color. Use a diverging palette if positive and negative values need to be distinguished.

Exercise 2: Sales by Product Sub-Category

Place Sub-Category on Rows and Region on Columns. Use Sales on Color and Text. Identify the high- and low-sales combinations.

Exercise 3: Monthly Sales Performance

Create a table with Month on Columns and Category on Rows. Use Sales to color the cells and add a Year filter.

Exercise 4: Customer Segment Analysis

Compare Profit by Segment and Region. Add labels or tooltips and explain which combinations need further investigation.

Exercise 5: Create a Dashboard

Build a dashboard containing a highlight table and a supporting bar chart. Add a Region filter and test how the views respond to selections.

24. Mini Project: Regional Sales and Profit Analysis

Project Objective: Develop a Tableau dashboard that enables business users to compare sales and profit across regions, product categories, and customer segments.

Project Requirements

• Connect Tableau to Sample - Superstore or a suitable business dataset.
• Create a highlight table with Region and Product Sub-Category.
• Use Profit to determine the cell colors.
• Display exact profit values where practical.
• Choose a palette that distinguishes positive and negative profit.
• Create a second worksheet for Sales by Category.
• Add filters for Region, Segment, or Year as appropriate.
• Place the worksheets on a dashboard.
• Use consistent formatting, readable labels, and clear legends.
• Write a short summary of the patterns revealed by the table.

Expected Learning Outcomes

• Create a highlight table using Tableau.
• Use color to compare numerical values across categories.
• Format cell size, borders, labels, and tooltips.
• Choose appropriate color palettes.
• Build an interactive dashboard for business analysis.

25. Interview Questions and Answers

Q1. What is a highlight table in Tableau?

Answer: A highlight table is a tabular visualization that uses color to emphasize differences in numerical values across rows and columns.

Q2. What is the main purpose of a highlight table?

Answer: Its purpose is to make high, low, positive, negative, or otherwise important values easier to identify within a grid of data.

Q3. How do you create a highlight table in Tableau?

Answer: Place dimensions on Rows and Columns, select Square as the mark type, and place a measure on Color. Add the measure to Text if you want exact values displayed.

Q4. What is the difference between a highlight table and a heat map?

Answer: A highlight table usually emphasizes tabular values through color, while a heat map can use both color and size to encode measures.

Q5. What is the purpose of the Color shelf?

Answer: The Color shelf controls the color of the marks. When a measure is placed there, the color represents its values according to the selected palette.

Q6. Why would you place a measure on Text?

Answer: Placing a measure on Text displays the exact numerical value in each cell, allowing viewers to combine precise figures with visual color comparisons.

Q7. When should you use a diverging color palette?

Answer: Use a diverging palette when there is a meaningful midpoint or threshold, such as zero profit, a target value, or a neutral percentage change.

Q8. When should you use a sequential color palette?

Answer: Use a sequential palette when values progress from low to high, such as sales revenue or order quantity.

Q9. How can you make a highlight table easier to read?

Answer: Use an appropriate color palette, readable labels, consistent number formats, suitable cell sizes, a clear legend, and filters when necessary.

Q10. Can highlight tables be used in dashboards?

Answer: Yes. Highlight tables can be placed on Tableau dashboards and combined with filters, supporting charts, and interactive actions.

Q11. Why might two measures need separate color legends?

Answer: Different measures may have different units and numerical ranges. Separate, clearly labeled legends help avoid misleading comparisons.

Q12. What is the difference between a highlight table and a normal text table?

Answer: A normal text table mainly displays numerical values, while a highlight table adds color encoding to make patterns and differences easier to identify.

26. Quick Revision Checklist

• ☐ I understand the purpose of a highlight table.
• ☐ I know how dimensions and measures are used.
• ☐ I can create a highlight table using Show Me.
• ☐ I can build a highlight table manually using the Marks card.
• ☐ I can use Color to encode a measure.
• ☐ I can use Text to display exact numerical values.
• ☐ I can distinguish highlight tables from heat maps.
• ☐ I understand sequential and diverging color palettes.
• ☐ I can format cell borders, size, labels, and tooltips.
• ☐ I can add filters and use a highlight table in a dashboard.
• ☐ I can interpret patterns without assuming that color alone explains the cause.

27. Official Tableau Learning Resources

• Tableau Official Guide: Build a Highlight Table or Heat Map
• Tableau: Understanding Highlight Tables and Heat Maps
• Tableau Official Guide: Highlight Actions

28. Conclusion

Highlight tables are useful Tableau visualizations for comparing numerical values across categories in a clear, color-coded grid. By combining dimensions, measures, color encoding, and optional numerical labels, analysts can identify patterns and areas that require attention. Choosing a suitable palette, keeping labels readable, and ensuring that the aggregation is correct are essential for creating accurate and effective highlight tables.

To continue learning Tableau, visit JustAcademy Tableau Training or Register for a Tableau Course Demo.