Highlight actions in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

How does a Highlight Action work in Tableau?

In Tableau, what happens when you use a Highlight Action on a dashboard?

A It removes all marks except the selected ones from the view.

B It filters the data to show only the selected marks.

C It changes the color of selected marks to emphasize them while keeping others visible.

D It exports the selected data to a new worksheet automatically.

💡 Hint

Think about what 'highlight' means visually on a dashboard.

A Highlight Action changes the color or style of selected marks to make them stand out, but it does not filter or remove other data points.

❓ dax_lod_result

intermediate

Result of Highlight Action on Color Encoding

Suppose you have a Tableau dashboard with a Highlight Action set on a category field. What is the expected visual output when you select a category?

A Only the selected category's marks remain colored; all others turn gray.

B All marks change to the same color regardless of category.

C The selected category's marks become larger but keep their original color.

D The selected category's marks disappear from the view.

💡 Hint

Highlight Actions usually change color intensity or brightness.

When a category is selected, Highlight Actions dim other categories by turning them gray and keep the selected category colored to emphasize it.

❓ visualization

advanced

Designing a Dashboard with Highlight Actions

You want to create a dashboard where selecting a bar in a sales chart highlights related customer segments in another chart without filtering them out. Which Tableau feature should you use?

A Use a Filter Action between the charts.

B Use a Highlight Action between the charts.

C Use a URL Action to link the charts.

D Use a Parameter Action to change the data source.

💡 Hint

Think about keeping all data visible but emphasizing related parts.

Highlight Actions emphasize related data points across charts without filtering out any data, perfect for this scenario.

🔧 Formula Fix

advanced

Why is the Highlight Action not working as expected?

You set up a Highlight Action on a dashboard, but when you select marks, nothing changes visually. What is the most likely cause?

A The data source is not connected to the workbook.

B The Highlight Action is set to run on hover instead of select.

C The dashboard has too many sheets for Highlight Actions to work.

D The source and target sheets do not share any common fields.

💡 Hint

Highlight Actions require a link between sheets.

Highlight Actions need common fields between source and target sheets to know which marks to highlight. Without shared fields, no highlight occurs.

🎯 Scenario

expert

Combining Highlight Actions with Filters for Advanced Interaction

You want a dashboard where selecting a region highlights related sales categories in one chart and filters the product list in another chart simultaneously. How should you configure the actions?

A Create a Highlight Action between region and sales categories, and a Filter Action between region and product list.

B Create two Highlight Actions: one for sales categories and one for product list.

C Create two Filter Actions: one for sales categories and one for product list.

D Create a Parameter Action to control both sales categories and product list.

💡 Hint

Think about when to highlight vs when to filter data.

Highlight Actions emphasize related data without hiding it, while Filter Actions reduce data shown. Combining both allows highlighting sales categories and filtering product list as required.

Practice

1. What is the main purpose of a Highlight Action in Tableau dashboards?

easy

A. To make related data points stand out without filtering the data

B. To permanently remove unrelated data from the view

C. To create new calculated fields based on user input

D. To export the dashboard data to Excel automatically

Solution

1. Step 1: Understand Highlight Action functionality

   Highlight actions emphasize related data visually but do not filter or remove data.

2. Step 2: Compare with other actions

   Unlike filter actions, highlight actions only change appearance to help users explore data connections.

3. Final Answer:

   To make related data points stand out without filtering the data -> Option A

4. Quick Check:

   Highlight actions emphasize data without filtering [OK]

Hint: Highlight actions emphasize data visually, not filter it [OK]

Common Mistakes:

• Confusing highlight with filter actions
• Thinking highlight removes data
• Assuming highlight creates new data

2. Which of the following is the correct way to create a Highlight Action in Tableau?

easy

A. Dashboard > Actions > Add Action > Highlight

B. Worksheet > Filter > Add Highlight

C. Data > Create Highlight Calculation

D. Format > Highlight Settings

Solution

1. Step 1: Locate where to add Highlight Actions

   Highlight actions are added via the Dashboard menu under Actions.

2. Step 2: Confirm correct menu path

   The correct path is Dashboard > Actions > Add Action > Highlight.

3. Final Answer:

   Dashboard > Actions > Add Action > Highlight -> Option A

4. Quick Check:

   Highlight actions are added from Dashboard menu [OK]

Hint: Add highlight actions from Dashboard > Actions menu [OK]

Common Mistakes:

• Trying to add highlight from Worksheet or Data menus
• Confusing highlight with filter or format options
• Looking for highlight in wrong menu

3. Consider a dashboard with a bar chart and a map. You set a Highlight Action from the bar chart to the map on the 'Region' field. What happens when you click a bar representing 'West' region?

medium

A. The entire map refreshes with new data unrelated to 'West'

B. The map filters to show only 'West' region data

C. Only the 'West' region data on the map is highlighted, others dimmed

D. Nothing happens because highlight actions do not work between charts

Solution

1. Step 1: Understand highlight action effect on target view

   Highlight actions emphasize matching data points and dim others but do not filter.

2. Step 2: Apply to example

   Clicking 'West' bar highlights 'West' region on map, dimming other regions visually.

3. Final Answer:

   Only the 'West' region data on the map is highlighted, others dimmed -> Option C

4. Quick Check:

   Highlight action dims non-matching data [OK]

Hint: Highlight dims unrelated data, does not filter [OK]

Common Mistakes:

• Thinking highlight filters data
• Assuming highlight does nothing between charts
• Confusing highlight with refresh or reload

4. You created a Highlight Action but clicking on the source chart does not highlight anything on the target chart. What is the most likely cause?

medium

A. You must refresh the dashboard manually after creating highlight actions

B. The fields used for linking source and target are different or mismatched

C. Highlight actions only work on maps, not charts

D. Highlight actions require filters to be enabled first

Solution

1. Step 1: Check linking fields in highlight action

   Highlight actions depend on matching fields between source and target views.

2. Step 2: Identify mismatch issue

   If fields differ or have different data types, highlight will not work.

3. Final Answer:

   The fields used for linking source and target are different or mismatched -> Option B

4. Quick Check:

   Matching fields are required for highlight to work [OK]

Hint: Ensure source and target fields match exactly for highlight [OK]

Common Mistakes:

• Assuming highlight needs filters enabled
• Thinking highlight only works on maps
• Forgetting to check field data types

5. You want to create a dashboard where clicking on a product category highlights related sales data across multiple charts without filtering any data. Which Tableau feature should you use and how should you configure it?

hard

A. Use URL Actions to open filtered views in new browser tabs

B. Use Filter Actions linking the 'Product Category' field and apply to all charts

C. Create a parameter to select product category and use calculated fields to filter charts

D. Use Highlight Actions linking the 'Product Category' field across all charts

Solution

1. Step 1: Identify requirement to highlight without filtering

   The goal is to emphasize related data without removing any data points.

2. Step 2: Choose appropriate action type

   Highlight Actions visually emphasize data; Filter Actions remove data points.

3. Step 3: Configure highlight action

   Link 'Product Category' field across all charts using Highlight Actions to achieve the goal.

4. Final Answer:

   Use Highlight Actions linking the 'Product Category' field across all charts -> Option D

5. Quick Check:

   Highlight actions emphasize data without filtering [OK]

Hint: Highlight actions emphasize related data without filtering [OK]

Common Mistakes:

• Choosing filter actions which remove data
• Using parameters unnecessarily
• Confusing URL actions with highlighting