Highlight tables in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the correct way to create a highlight table in Tableau

You want to create a highlight table that colors cells based on sales values. Which option correctly describes the steps to achieve this?

A Drag 'Sales' to Rows, 'Category' to Columns, and set 'Sales' as a filter.

B Drag 'Sales' to Color on the Marks card and 'Category' to Rows, 'Sub-Category' to Columns.

C Drag 'Category' to Color and 'Sales' to Size on the Marks card.

D Drag 'Sub-Category' to Detail and 'Profit' to Tooltip.

💡 Hint

Highlight tables use color to show measure values across categories.

Dragging the measure 'Sales' to Color and dimensions to Rows and Columns creates a highlight table where color intensity shows sales values.

❓ dax_lod_result

intermediate

Calculate total sales per category for a highlight table

Given a sales table with columns 'Category' and 'SalesAmount', which DAX measure correctly calculates total sales per category for use in a highlight table?

Tableau

Total Sales by Category = SUM(Sales[SalesAmount])

A Total Sales by Category = AVERAGE(Sales[SalesAmount])

B Total Sales by Category = CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales))

C Total Sales by Category = COUNT(Sales[Category])

D Total Sales by Category = SUM(Sales[SalesAmount])

💡 Hint

Sum the sales amount grouped by category.

SUM aggregates sales amounts per category automatically when used in a visual with category dimension.

🧠 Conceptual

advanced

Why use highlight tables instead of regular tables?

What is the main advantage of using highlight tables over regular tables in business intelligence dashboards?

A Highlight tables use color to quickly show patterns and outliers in data.

B Highlight tables reduce the number of rows displayed to improve performance.

C Highlight tables automatically group data by date hierarchy.

D Highlight tables replace the need for charts and graphs.

💡 Hint

Think about how color helps in understanding data.

Highlight tables add color shading to cells, making it easier to spot trends and differences at a glance.

🔧 Formula Fix

advanced

Identify the error in this Tableau highlight table setup

You created a highlight table but the colors do not change based on sales values. What is the likely cause?

Setup: 'Category' on Rows, 'Sub-Category' on Columns, 'Sales' on Size, but no field on Color.

A 'Sales' should be on Tooltip instead of Size.

B 'Category' should be on Columns, not Rows.

C Missing 'Sales' on Color; size does not control color intensity.

D You need to add 'Profit' to Color for sales to show.

💡 Hint

Color controls the shading in highlight tables.

Highlight tables rely on color to show measure intensity. Using size alone won't color the cells.

🎯 Scenario

expert

Design a highlight table to compare monthly sales across regions

You have sales data by month and region. You want a highlight table that shows months on rows, regions on columns, and colors cells by total sales. Which Tableau setup achieves this?

A Place 'Month' on Rows, 'Region' on Columns, and drag 'Sales' to Color on the Marks card.

B Place 'Region' on Rows, 'Month' on Columns, and drag 'Sales' to Size on the Marks card.

C Place 'Month' on Columns, 'Region' on Rows, and drag 'Sales' to Tooltip.

D Place 'Sales' on Rows, 'Month' on Columns, and 'Region' on Color.

💡 Hint

Highlight tables use color to show measure values across two dimensions.

Placing months on rows and regions on columns with sales on color creates a grid where color intensity shows sales per month-region pair.

Practice

1. What is the main purpose of a highlight table in Tableau?

easy

A. To use color to make numbers easier to compare

B. To create complex calculations with multiple measures

C. To display geographic data on a map

D. To filter data based on user input

Solution

1. Step 1: Understand the function of highlight tables

   Highlight tables use color shading to help users quickly compare numbers visually.

2. Step 2: Compare options with this function

   Only To use color to make numbers easier to compare describes using color to make numbers easier to compare, which matches the purpose of highlight tables.

3. Final Answer:

   To use color to make numbers easier to compare -> Option A

4. Quick Check:

   Highlight tables = color for comparison [OK]

Hint: Highlight tables use color to compare numbers quickly [OK]

Common Mistakes:

• Confusing highlight tables with maps
• Thinking highlight tables filter data
• Assuming highlight tables create complex calculations

2. Which of the following is the correct way to create a highlight table in Tableau?

easy

A. Place a dimension on Rows and a measure on Columns only

B. Use a calculated field with IF statements

C. Put a measure on both Text and Color shelves

D. Drag a dimension to the Filters shelf

Solution

1. Step 1: Recall how to build highlight tables

   Highlight tables require placing a measure on Text to show numbers and on Color to shade cells by value.

2. Step 2: Evaluate each option

   Only Put a measure on both Text and Color shelves correctly describes putting a measure on both Text and Color shelves to create a highlight table.

3. Final Answer:

   Put a measure on both Text and Color shelves -> Option C

4. Quick Check:

   Measure on Text + Color = highlight table [OK]

Hint: Use measure on Text and Color shelves for highlight tables [OK]

Common Mistakes:

• Only placing measure on Rows or Columns
• Using calculated fields unnecessarily
• Confusing Filters with Color shelf

3. Given a highlight table with Sales as the measure on Text and Color, what will happen if Sales values increase in some cells?

medium

A. Those cells will show lower numbers but darker color shading

B. Those cells will show higher numbers and darker color shading

C. The color will not change but numbers will update

D. The table will automatically filter out those cells

Solution

1. Step 1: Understand highlight table behavior

   Highlight tables use color intensity to represent measure values; higher values get darker or stronger color.

2. Step 2: Analyze effect of increasing Sales values

   When Sales increase, the number on Text updates to the higher value and the color shade becomes darker to reflect the increase.

3. Final Answer:

   Those cells will show higher numbers and darker color shading -> Option B

4. Quick Check:

   Higher value = darker color + bigger number [OK]

Hint: Higher measure values mean darker color and bigger numbers [OK]

Common Mistakes:

• Thinking color stays the same when values change
• Assuming color gets lighter with higher values
• Believing highlight tables filter data automatically

4. You created a highlight table but the color shading does not appear. What is the most likely cause?

medium

A. You placed the measure only on Text but not on Color

B. You used a dimension on Color instead of a measure

C. You applied a filter that hides all data

D. You forgot to add a dimension to Rows or Columns

Solution

1. Step 1: Identify why color shading might be missing

   Highlight tables require a measure on the Color shelf to apply shading based on values.

2. Step 2: Check the options for missing color shading

   You placed the measure only on Text but not on Color states the measure is only on Text, so no color shading can appear. This is the most common cause.

3. Final Answer:

   You placed the measure only on Text but not on Color -> Option A

4. Quick Check:

   Measure missing on Color = no shading [OK]

Hint: Always put measure on Color shelf for shading [OK]

Common Mistakes:

• Using dimension on Color instead of measure
• Forgetting to add any dimension to Rows or Columns
• Assuming filters cause missing color shading

5. You want to highlight the top 10 products by Sales in a highlight table. Which approach correctly applies this filter while keeping the highlight table format?

hard

A. Use a Top N filter on Product dimension and place Sales on Text and Color

B. Place Product on Color shelf and Sales on Text shelf

C. Filter Sales measure to show only values above a fixed threshold

D. Create a calculated field to rank products and filter by rank, then use Sales on Text and Color

Solution

1. Step 1: Understand filtering top N in highlight tables

   Using a calculated rank field allows precise filtering of top 10 products without losing highlight table structure.

2. Step 2: Evaluate each option

   Create a calculated field to rank products and filter by rank, then use Sales on Text and Color uses a rank calculation to filter top 10, then places Sales on Text and Color, preserving highlight table format correctly.

3. Final Answer:

   Create a calculated field to rank products and filter by rank, then use Sales on Text and Color -> Option D

4. Quick Check:

   Rank filter + Sales on Text and Color = top 10 highlight table [OK]

Hint: Use rank calculation to filter top N in highlight tables [OK]

Common Mistakes:

• Using simple Top N filter that breaks highlight table
• Filtering Sales by threshold instead of ranking products
• Placing dimension on Color shelf instead of measure