Text Tables and Heat Maps in Tableau
Learn how to create text tables, crosstabs, highlight tables and heat maps in Tableau. Understand how to display exact values, compare measures across categories, apply color encoding and identify performance patterns using effective table-based visualizations.
1. Introduction to Text Tables and Heat Maps
Tableau provides several ways to display information in a structured tabular format. Text tables display exact numeric or textual values arranged in rows and columns, while heat maps use color intensity to communicate differences between values.
These visualizations are useful when users need to examine detailed information, compare multiple categories, identify high and low performing areas and understand patterns across a dataset.
For example, a business may want to compare sales across different regions and product categories. A text table can display the exact sales amount, while a heat map can highlight which combinations have higher or lower sales.
Why use Text Tables and Heat Maps?
- Display exact numeric and textual values.
- Compare multiple dimensions and measures.
- Identify high-performing and low-performing categories.
- Highlight patterns using color intensity.
- Support detailed business reporting.
- Make large data summaries easier to explore.
2. What is a Text Table in Tableau?
A Text Table is a visualization that displays data in rows and columns. It is also commonly known as a crosstab or data table. Each cell contains a text value, numeric measure or aggregated result.
Text tables are useful when users need to read exact values instead of interpreting graphical representations. They are commonly used in financial reports, sales summaries, inventory reports and operational dashboards.
Example: Regional Sales Summary
| Region | Technology | Furniture | Office Supplies | Total Sales |
|---|---|---|---|---|
| East | 45,000 | 25,000 | 18,000 | 88,000 |
| West | 55,000 | 32,000 | 20,000 | 107,000 |
| Central | 38,000 | 28,000 | 15,000 | 81,000 |
| South | 42,000 | 30,000 | 17,000 | 89,000 |
In this example, each row represents a region, while each product category is displayed as a separate column. The table allows users to compare exact sales values across regions.
Characteristics of Text Tables
- Display exact values in a structured layout.
- Support multiple dimensions and measures.
- Allow sorting and filtering.
- Can display subtotals and grand totals.
- Support formatting, labels and number formats.
- Can be used as part of a Tableau dashboard.
3. How to Create a Text Table in Tableau
Tableau provides the Text Table option through Show Me. Users can also create a table manually by placing dimensions and measures on the Rows and Columns shelves and configuring the Marks Card.
Steps to Create a Text Table
- Open Tableau Desktop or Tableau Public.
- Connect to a dataset containing dimensions and measures.
- Open a new worksheet.
- Drag Region to the Rows shelf.
- Drag Category to the Columns shelf.
- Drag Sales to the Text option on the Marks Card.
- Alternatively, select the required fields and choose Text Table from Show Me.
- Review the generated table and confirm that the values are aggregated as expected.
- Format the numbers and headers for readability.
- Rename the worksheet to Regional Sales Crosstab.
4. Understanding Crosstab in Tableau
A crosstab is a tabular representation of data that organizes information across row and column dimensions. It helps users compare measures at the intersection of different categories.
For example, Region can be placed on Rows and Category on Columns. Sales can then be displayed in each cell. This creates a cross-category summary that helps users compare business performance.
Common Crosstab Components
| Component | Purpose |
|---|---|
| Row Headers | Display the dimension values arranged vertically. |
| Column Headers | Display dimension values arranged horizontally. |
| Cell Values | Display measures or aggregated results. |
| Subtotals | Summarize values for groups of records. |
| Grand Total | Display an overall summary across the view. |
How to Create a Crosstab
- Open a new worksheet.
- Drag a dimension such as Region to Rows.
- Drag another dimension such as Category to Columns.
- Drag a measure such as Sales to Text on the Marks Card.
- Review the values displayed at each row-column intersection.
- Use sorting and formatting to improve the table.
- Enable totals when an overall summary is required.
5. What is a Highlight Table in Tableau?
A Highlight Table combines a text table with color encoding. It displays values in a grid while using different colors to emphasize high, low or intermediate values.
Unlike a plain text table, a highlight table makes patterns easier to identify because users can recognize differences through color intensity while still reading the actual numeric values.
Example: Regional Sales Performance
Consider a business that wants to compare sales across four regions and three product categories. A highlight table can display the sales amounts and use stronger colors for higher sales values.
| Region | Technology | Furniture | Office Supplies |
|---|---|---|---|
| East | 45,000 | 25,000 | 18,000 |
| West | 55,000 | 32,000 | 20,000 |
| Central | 38,000 | 28,000 | 15,000 |
| South | 42,000 | 30,000 | 17,000 |
In this illustrative example, darker blue cells represent relatively higher sales and lighter cells represent relatively lower sales. The exact colors and value ranges depend on the color settings used in Tableau.
Steps to Create a Highlight Table
- Connect Tableau to the sales dataset.
- Open a new worksheet.
- Drag Region to Rows.
- Drag Category to Columns.
- Drag Sales to Text on the Marks Card.
- Drag Sales again to Color on the Marks Card.
- Use Show Me and select Highlight Table if the selected fields support it.
- Open the Color options to adjust the color palette.
- Review the color legend and displayed values.
- Rename the worksheet to Regional Sales Highlight Table.
6. What is a Heat Map in Tableau?
A heat map is a visualization that represents data through a collection of colored rectangular marks. The color and size of each mark can represent different measures, helping users identify patterns and variations across categories.
In Tableau, heat maps are commonly created by placing dimensions on Rows and Columns and using measures on the Color and Size properties of the Marks Card. The exact visual appearance depends on the selected fields and mark configuration.
How a Heat Map Works
- Rows and Columns define the categories displayed in the grid.
- Color represents the magnitude or category of a measure.
- Size can represent another measure to add a second visual encoding.
- Tooltips provide additional details when users hover over a mark.
Example: Product Performance Heat Map
A retail company may want to analyze product performance across different regions. A heat map can use Region and Product Category as dimensions, Sales as Color and Profit as Size.
7. How to Create a Heat Map in Tableau
Tableau provides the Heat Map option through Show Me when the selected fields support that visualization. Users can also build a heat map manually by configuring the Marks Card.
Steps to Create a Heat Map
- Connect to a dataset containing dimensions and numeric measures.
- Open a new worksheet.
- Drag Region to Rows.
- Drag Category to Columns.
- Select the required dimensions and measures in the Data Pane.
- Open Show Me and choose Heat Map if available for the selected fields.
- Alternatively, use the Marks Card to select Square.
- Drag Sales to Color.
- Drag Profit or another measure to Size if a second encoding is required.
- Use Tooltip to display detailed information.
- Adjust colors, size and formatting for readability.
- Rename the worksheet to Product Performance Heat Map.
Important Configuration Options
| Option | Purpose |
|---|---|
| Rows | Defines the categories displayed vertically. |
| Columns | Defines the categories displayed horizontally. |
| Color | Represents the value or category using different colors. |
| Size | Controls the size of the marks based on a measure. |
| Tooltip | Displays additional details when the user hovers over a mark. |
| Filters | Limits the data displayed in the heat map. |
8. Understanding Color Encoding
Color encoding is the process of using colors to represent values, categories or performance levels in a visualization. It helps users identify differences and patterns without examining every value individually.
Tableau provides color palettes that can be applied to marks. The appropriate palette depends on whether the measure is continuous, whether the values have a meaningful midpoint, or whether the colors represent distinct categories.
Common Color Palette Types
| Palette Type | Description | Example Use |
|---|---|---|
| Sequential | Uses a gradual change from lighter to darker shades. | Sales volume or population. |
| Diverging | Uses two color directions around a meaningful midpoint. | Profit and loss around zero. |
| Qualitative | Uses distinct colors for separate categories. | Region or product category. |
How to Change Colors in Tableau
- Open the worksheet containing the table or heat map.
- Locate the Marks Card.
- Click Color.
- Select Edit Colors.
- Choose an appropriate color palette.
- Adjust the range or center when the selected continuous color scale supports it.
- Apply the changes and review the result.
9. Formatting Text Tables and Heat Maps
Formatting improves the readability and presentation of tabular visualizations. Tableau provides formatting controls for fonts, alignment, borders, shading, number formats and totals.
Important Formatting Options
| Formatting Option | Purpose |
|---|---|
| Font | Changes the font family, size and style of text. |
| Alignment | Controls horizontal and vertical text positioning. |
| Shading | Applies background colors to headers, panes or cells. |
| Borders | Separates rows, columns and sections visually. |
| Number Format | Displays currency, percentage, decimal and other number formats. |
| Totals | Displays subtotals and grand totals where appropriate. |
Steps to Format a Text Table
- Open the text table worksheet.
- Open the Format menu.
- Select the formatting area that needs modification.
- Adjust font and alignment settings.
- Set suitable number formats for numeric measures.
- Adjust row and column sizes if required.
- Use borders and shading carefully.
- Review the complete table before using it in a dashboard.
10. Adding Subtotals and Grand Totals
Totals help users understand aggregated values across rows and columns. Tableau can calculate subtotals and grand totals for measures in a view, depending on the structure of the worksheet.
Types of Totals
- Row Subtotals: Summarize values across columns for a particular row grouping.
- Column Subtotals: Summarize values across rows for a particular column grouping.
- Grand Total: Displays an overall total for the view.
Steps to Add Totals
- Open a worksheet containing a text table or crosstab.
- Open the Analysis menu.
- Locate Totals.
- Choose the required subtotal or grand total option.
- Review the generated totals.
- Verify that the aggregation is appropriate for the measure.
11. Practical Example: Create a Regional Sales Heat Map
In this practical exercise, we will create a regional sales heat map using a dataset that contains Region, Category, Sales and Profit. The objective is to compare sales performance across regions and product categories.
Step 1: Connect to the Dataset
- Open Tableau Desktop or Tableau Public.
- Connect to the sales dataset.
- Review the available dimensions and measures.
- Confirm that Region and Category are dimensions.
- Confirm that Sales and Profit are numeric measures.
Step 2: Create the Text Table
- Create a new worksheet.
- Drag Region to Rows.
- Drag Category to Columns.
- Drag Sales to Text on the Marks Card.
- Verify that the table displays the expected aggregated sales values.
- Rename the worksheet to Regional Sales Table.
Step 3: Convert the Table into a Highlight Table
- Keep Region on Rows and Category on Columns.
- Drag Sales to Color.
- Open Show Me and choose Highlight Table if available.
- Review the color legend.
- Adjust the palette to make higher and lower values distinguishable.
Step 4: Create a Heat Map
- Create a new worksheet.
- Place Region on Rows and Category on Columns.
- Select Square from the Marks Card.
- Drag Sales to Color.
- Drag Profit to Size if you want to show another measure.
- Use Tooltip to display Region, Category, Sales and Profit.
- Adjust the mark size and color palette.
- Rename the worksheet to Regional Performance Heat Map.
Step 5: Compare the Results
Review the text table, highlight table and heat map. The text table provides exact values, the highlight table emphasizes differences through color while retaining the numbers, and the heat map provides a visual overview through color and mark size. Select the view that best supports the reporting requirement.
12. Difference Between Text Table, Highlight Table and Heat Map
| Feature | Text Table | Highlight Table | Heat Map |
|---|---|---|---|
| Main Purpose | Display exact values. | Display values with color emphasis. | Show patterns using color and mark size. |
| Text Values | Primary visual information. | Displayed inside colored cells. | May be displayed through labels or tooltips. |
| Color Encoding | Optional. | Important visual component. | Important visual component. |
| Size Encoding | Not normally the main encoding. | Not normally the main encoding. | Can represent a measure. |
| Best Use | Detailed reporting. | Comparing values in a grid. | Identifying patterns and concentration. |
13. Common Mistakes While Creating Tables and Heat Maps
| Mistake | Problem | Recommended Practice |
|---|---|---|
| Using too many colors | Creates confusion and reduces readability. | Use a limited and meaningful color palette. |
| Ignoring color legends | Users may misunderstand the meaning of colors. | Display clear legends and appropriate labels. |
| Displaying too many decimal places | Makes the table unnecessarily crowded. | Use appropriate number formatting. |
| Using an unsuitable color scale | May exaggerate or hide differences. | Choose sequential or diverging palettes based on the measure. |
| Ignoring aggregation | Can produce misleading summaries. | Verify SUM, AVG, COUNT and other aggregations. |
| Adding too many dimensions | Creates a large and difficult-to-read table. | Keep the view focused on the required analysis. |
| Using color without readable values | Users may not know the exact value represented. | Show labels or provide useful tooltips when needed. |
14. Best Practices for Text Tables and Heat Maps
- Use text tables when exact values are important.
- Use highlight tables to compare values across categories.
- Use heat maps to identify patterns and concentration.
- Choose a color palette that matches the meaning of the measure.
- Use sequential colors for ordered numeric values.
- Use diverging colors when values have a meaningful midpoint.
- Use qualitative colors for distinct categories.
- Keep row and column headers clear.
- Format currency, percentages and numeric values consistently.
- Use tooltips to provide additional information.
- Check totals and aggregation settings before publishing.
- Ensure that color differences are understandable and accessible.
Summary
Text Tables and Heat Maps in Tableau are useful for presenting structured information and identifying patterns in data. Text tables display exact values in rows and columns, while crosstabs organize measures across multiple dimensions. Highlight tables combine numeric values with color encoding to make comparisons easier, whereas heat maps use color intensity and optionally mark size to communicate variations across categories. Tableau provides Show Me, the Marks Card, formatting options, color palettes and totals to help users create effective table-based visualizations. By selecting appropriate fields, aggregations and colors, users can build clear and informative business reports.