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.