Filter Actions and Highlight Actions in Tableau – Complete Detailed Notes

Topic: Filter Actions and Highlight Actions

Tool: Tableau Desktop, Tableau Cloud, and Tableau Server

Objective: Learn how to create, configure, compare, and troubleshoot filter actions and highlight actions to build interactive Tableau worksheets and dashboards.

1. Introduction to Filter Actions and Highlight Actions

Tableau is a business intelligence and data visualization tool that helps users analyze information through charts, tables, maps, and dashboards. Interactive actions allow users to explore data by clicking, hovering over, or selecting marks in a visualization.

Two important Tableau actions are Filter Actions and Highlight Actions. Both help users investigate relationships between data points, but they work differently.

• Filter Action: Filters a target worksheet based on the values selected in a source worksheet.
• Highlight Action: Emphasizes related marks in a visualization while keeping other marks visible for comparison.

For example, a sales dashboard might contain a regional map, a product category chart, and a customer table. Selecting Maharashtra on the map can filter the other charts to show Maharashtra-specific information. Alternatively, a highlight action can emphasize Maharashtra-related marks while keeping other regions visible.

According to Tableau's official documentation, filter actions transfer selected field values to target views, while highlight actions call attention to relevant marks by visually de-emphasizing others. Read about Filter Actions and Read about Highlight Actions.

2. What Is a Filter Action in Tableau?

A Filter Action is an interactive feature that passes selected field values from a source view to one or more target views. Tableau applies those values as filters so that the target worksheets display only the relevant data.

2.1 Example of a Filter Action

Imagine a retail sales dashboard containing the following worksheets:

• Sales by Region
• Sales by Category
• Monthly Sales Trend
• Customer Order Details

When a user selects the West region in the Sales by Region chart, the other worksheets can update to show information related to the West region.

Sales by Region
      |
      | Select West
      v
   Filter Action
      |
      +------> Sales by Category
      |
      +------> Monthly Sales Trend
      |
      +------> Customer Order Details

2.2 Why Use Filter Actions?

• To focus on a specific subset of data.
• To connect multiple worksheets in a dashboard.
• To explore details without creating separate dashboards for every category or region.
• To reduce the need for multiple visible filter controls.
• To support drill-down analysis from summary charts to detailed records.
• To help users identify trends and investigate business questions quickly.

2.3 Common Uses of Filter Actions

3. Important Concepts of Filter Actions

3.1 Source Worksheet

The source worksheet is where the user begins the interaction. It contains the marks from which Tableau obtains the selected field values.

Example: A bar chart showing sales by region is the source worksheet when the user selects a region.

3.2 Target Worksheet

The target worksheet is the view that receives the action and responds to the selected values.

Example: A product table is the target worksheet when selecting a region filters the table to display products sold in that region.

3.3 Marks

Marks are visual representations of data in a Tableau view. They may appear as bars, circles, map symbols, lines, or text. Users can interact with these marks to trigger an action.

3.4 Action Trigger

The trigger defines how the action starts. Common choices are Hover, Select, and Menu.

3.5 Clearing the Selection

This setting defines what happens when a user clears a selection in the source view. The available choices commonly include showing all values, leaving the filter in place, or excluding all values.

4. Types of Filter Action Triggers

4.1 Hover Trigger

Hover actions can make a dashboard feel responsive because users do not need to click each mark. However, they can also cause frequent updates when the pointer moves across many marks.

4.2 Select Trigger

Select actions are useful when the user should deliberately choose a mark before filtering the target worksheets. They are often a good default for business dashboards.

4.3 Menu Trigger

Menu actions give users explicit control over when to run an action. This can be helpful when the interaction should not occur automatically during hovering or selection.

5. Steps to Create a Filter Action in Tableau

The following example uses the Sample - Superstore dataset.

Step 1: Connect to the Dataset

1. Open Tableau Desktop.
2. Connect to Sample - Superstore or another dataset with sales information.
3. Open a worksheet and confirm that the required fields are available.

Step 2: Create the Source Worksheet

1. Create a worksheet named Sales by Region.
2. Drag Region to Rows.
3. Drag Sales to Columns.
4. Choose a suitable bar chart.

Step 3: Create the Target Worksheet

1. Create another worksheet named Sales by Category.
2. Drag Category to Rows.
3. Drag Sales to Columns.
4. Optionally create a third worksheet containing order or customer details.

Step 4: Create a Dashboard

1. Select New Dashboard.
2. Add the Sales by Region worksheet.
3. Add the Sales by Category worksheet and any other target worksheets.
4. Arrange the views so the dashboard is easy to understand.

Step 5: Add the Filter Action

1. Open the dashboard.
2. Select Dashboard > Actions.
3. Click Add Action > Filter.
4. Enter a descriptive action name, such as Filter Sales by Region.
5. Select Sales by Region as the source sheet.
6. Under Run action on, select Hover, Select, or Menu.
7. Select Sales by Category and other appropriate worksheets as target sheets.
8. Configure the clearing-selection behavior.
9. Choose All Fields or Selected Fields for the target filters.
10. Click OK to save the action.

Step 6: Test the Filter Action

1. Click a region in the source chart.
2. Confirm that the target worksheets show the expected records.
3. Select another region and verify that the results change.
4. Clear the selection and verify the configured clearing behavior.

Official reference: Tableau Filter Actions – Configuration and Examples.

6. Understanding Filter Action Settings

6.1 Source Sheets

Source Sheets determines which worksheets can initiate the action. You can select one source worksheet or multiple worksheets, depending on the intended workflow.

6.2 Target Sheets

Target Sheets determines which worksheets respond to the selected values. Choose only the views that should be filtered to avoid confusing or unintended interactions.

6.3 All Fields

With All Fields, Tableau uses the applicable field values from the selected mark to filter the target view. If a mark is defined by several dimensions, multiple values can influence the target results.

Example: If a source mark represents a particular Region and Category, the target may be filtered by both values.

6.4 Selected Fields

Selected Fields allows the author to specify which source fields map to which target fields. This is useful when only a particular dimension should control the action or when source and target fields have different names.

Example: Map the source field Region to the target field Sales Region. Selecting a region then filters the target based on that field mapping.

6.5 Clearing the Selection

Some labels may differ slightly between Tableau Desktop and web authoring. Always test the configured behavior in the environment where the dashboard will be used.

7. What Is a Highlight Action in Tableau?

A Highlight Action is an interactive feature that emphasizes related marks in a worksheet or dashboard while keeping other marks visible. It helps users identify relationships without removing the rest of the data from view.

7.1 Example of a Highlight Action

Suppose a dashboard contains sales by category, profit by region, and a product chart. When the user selects Furniture in the category chart, a highlight action can emphasize Furniture-related marks in other views while the remaining categories stay visible.

Sales by Category
       |
       | Select Furniture
       v
   Highlight Action
       |
       +------> Emphasize related product marks
       |
       +------> Emphasize related regional marks
       |
       v
Other marks remain visible for comparison

7.2 Why Use Highlight Actions?

• To emphasize selected data without removing other marks.
• To compare a selected category with the full dataset.
• To reveal relationships across multiple worksheets.
• To investigate patterns and outliers while preserving context.
• To make interactive dashboards more intuitive.
• To compare related data points across different visualizations.

7.3 Common Uses of Highlight Actions

8. Types and Methods of Highlighting in Tableau

Tableau supports several ways to highlight marks. These include selecting marks manually, highlighting from legends, using a highlighter, and configuring advanced highlight actions.

8.1 Manual Mark Selection

Users can select marks in a worksheet to emphasize a selection and visually de-emphasize other marks. This is suitable for quick comparisons in smaller views.

8.2 Highlighting Through a Legend

When a visualization has a suitable color, size, or shape legend, selecting a legend member can highlight related marks. For example, selecting the Furniture category in a Category legend can emphasize Furniture marks.

8.3 Highlighter

A highlighter lets users search for or select values of a field and highlight the matching marks while preserving the surrounding data context. It can be useful when the view contains many values.

8.4 Advanced Highlight Action

An advanced highlight action is configured through the Actions dialog. It allows the author to specify source sheets, target sheets, the trigger, and the fields used to determine which marks should be highlighted.

Official reference: Create Advanced Highlight Actions in Tableau.

9. Steps to Create a Highlight Action in Tableau

Step 1: Create the Source Worksheet

1. Open Tableau and connect to Sample - Superstore.
2. Create a worksheet named Sales by Category.
3. Drag Category to Rows.
4. Drag Sales to Columns.
5. Choose a bar chart or another suitable visualization.

Step 2: Create the Target Worksheet

1. Create a worksheet named Sales by Product.
2. Drag Product Name to Rows.
3. Drag Sales to Columns.
4. Optionally use Category on Color so the relationship between categories and products is clear.

Step 3: Create a Dashboard

1. Create a new dashboard.
2. Add Sales by Category.
3. Add Sales by Product.
4. Arrange the charts so the source and target are easy to identify.

Step 4: Configure the Highlight Action

1. Select Dashboard > Actions.
2. Click Add Action > Highlight.
3. Enter a descriptive name, such as Highlight Selected Category.
4. Select Sales by Category as the source sheet.
5. Choose Hover, Select, or Menu as the trigger.
6. Select Sales by Product as the target sheet.
7. Choose the fields that determine which marks should be highlighted.
8. Click OK to save the action.

Step 5: Test the Highlight Action

1. Hover over or select a category in the source chart.
2. Observe which marks are emphasized in the target chart.
3. Confirm that unrelated marks remain visible.
4. Test other categories to verify that highlighting works consistently.

Important: The source and target views need suitable matching fields for the intended highlighting behavior. If the views do not share the expected field values, the action may not visibly highlight the correct marks.

10. Highlight Action Configuration Settings

10.1 Source Sheets

Select the worksheet or worksheets from which the user can trigger highlighting.

10.2 Target Sheets

Select the worksheets in which related marks should be highlighted. A dashboard may have several target views, but not every view needs to respond.

10.3 All Fields

All Fields means Tableau considers the applicable fields from the selected source mark when matching marks in the target view.

10.4 Dates and Times

This option matches marks using date and time values. It can be useful when the source and target worksheets use date fields with different names but represent the same time values.

10.5 Selected Fields

Selected Fields lets the author specify which field or fields determine the highlighting. For example, selecting the Category field can highlight target marks that share the selected category.

11. Filter Actions vs. Highlight Actions

Although filter and highlight actions both make Tableau dashboards interactive, their results are different. The choice depends on whether the user needs a focused subset of data or a visual comparison with the full dataset.

11.1 When Should You Use a Filter Action?

• When users need to view only a selected region, category, or customer group.
• When detailed tables should show only relevant records.
• When a summary chart should control the data displayed in other charts.
• When reducing the amount of visible information makes analysis easier.

11.2 When Should You Use a Highlight Action?

• When users need to compare a selection against the rest of the dataset.
• When preserving the full data context is important.
• When relationships between marks in multiple charts need to be emphasized.
• When removing unrelated data would make comparisons more difficult.

11.3 Can Filter and Highlight Actions Be Used Together?

Yes. Tableau supports multiple actions on the same dashboard. For example, selecting a region can filter a detailed order table while simultaneously highlighting that region's marks in a comparative chart. When combining actions, test their behavior carefully because Tableau processes action types in a defined order.

See Tableau Actions and Action Order for additional information.

12. Practical Project: Interactive Retail Sales Dashboard

Project Goal: Build a dashboard that uses both filter actions and highlight actions to help business users analyze sales performance.

12.1 Dataset

Use Sample - Superstore or a similar dataset with fields such as Order Date, Region, State, Category, Sub-Category, Product Name, Customer Name, Sales, Profit, and Quantity.

12.2 Create These Worksheets

1. Sales by Region: Region on Rows and Sales on Columns.
2. Sales by Category: Category on Rows and Sales on Columns.
3. Sales Trend: Order Date on Columns and Sales on Rows.
4. Profit by Product: Product Name on Rows and Profit on Columns.
5. Order Details: A table containing order, customer, product, sales, and profit information.

12.3 Add the Worksheets to a Dashboard

1. Create a new dashboard.
2. Place the regional chart near the top or left side.
3. Place the category chart and sales trend beside it.
4. Add the product chart and order details table.
5. Use clear titles and short instructions to explain how the dashboard works.

12.4 Configure the Filter Action

1. Open Dashboard > Actions.
2. Add a Filter action named Filter by Region.
3. Choose Sales by Region as the source.
4. Choose Select as the trigger.
5. Choose Sales by Category, Sales Trend, Profit by Product, and Order Details as the target sheets.
6. Configure clearing selection to Show all values if users should be able to return to the full dashboard.
7. Save and test the action.

12.5 Configure the Highlight Action

1. Open Dashboard > Actions.
2. Add a Highlight action named Highlight Selected Category.
3. Choose Sales by Category as the source.
4. Choose Hover or Select as the trigger.
5. Choose a suitable target chart, such as Profit by Product.
6. Configure highlighting using the Category field or another suitable shared field.
7. Save and test the action.

12.6 Expected Dashboard Behavior

12.7 Project Testing Checklist

• Verify that every source worksheet triggers the correct action.
• Confirm that the target worksheets respond as intended.
• Check field mappings for filter and highlight actions.
• Test multiple marks and different selections.
• Test the filter clearing behavior.
• Confirm that highlighting preserves the intended visual context.
• Review dashboard layout and instructions.
• Test performance with realistic data volumes.

13. Common Problems and Solutions

14. Best Practices for Filter and Highlight Actions

• Use meaningful action names: For example, “Filter by Region” or “Highlight Selected Category.”
• Keep interactions purposeful: Each action should help users answer a specific business question.
• Choose the right action: Use filters to focus on a subset and highlights to preserve comparison context.
• Select suitable triggers: Use Select for deliberate interactions and Hover for quick exploration.
• Map fields correctly: Ensure source and target fields represent compatible values.
• Configure reset behavior: Make it easy for users to return to the full dashboard when necessary.
• Provide instructions: Use text such as “Select a region to filter the charts” or “Hover over a category to highlight related products.”
• Avoid excessive actions: Too many interactions can confuse users and complicate dashboard maintenance.
• Test all selections: Include empty results, multiple marks, and cleared selections in testing.
• Monitor performance: Complex actions across many worksheets can increase query and rendering work.

15. Interview Questions and Answers

Q1. What is a filter action in Tableau?

Answer: A filter action passes selected field values from a source view to a target view and filters the target to show related records.

Q2. What is a highlight action in Tableau?

Answer: A highlight action emphasizes matching marks while keeping other marks visible, helping users compare selected data with the broader dataset.

Q3. What is the main difference between filter and highlight actions?

Answer: A filter action narrows the target view to matching data, while a highlight action visually emphasizes matching marks without generally removing the other marks.

Q4. What are source and target worksheets?

Answer: The source worksheet initiates the action, and the target worksheet responds to the selected values or highlighting criteria.

Q5. What are the three common action triggers?

Answer: Hover, Select, and Menu.

Q6. What is the purpose of Selected Fields in a filter action?

Answer: It lets the author choose which source and target fields determine the filtering instead of using all applicable fields.

Q7. What does Show all values do when a filter selection is cleared?

Answer: It removes the action filter from the target so all available values can be displayed again.

Q8. Can multiple worksheets be target sheets for one filter action?

Answer: Yes. A single action can affect multiple target worksheets when they are configured as targets.

Q9. What is an advanced highlight action?

Answer: It is a configurable highlight action that allows the author to define source sheets, target sheets, trigger behavior, and the fields used to match marks.

Q10. When is a highlight action better than a filter action?

Answer: A highlight action is better when users need to retain the full dataset for comparison while emphasizing a particular group of marks.

Q11. Can filter and highlight actions work together?

Answer: Yes. They can be combined to provide focused detail views and comparative highlighting, but their interaction and order should be tested.

Q12. How do you troubleshoot a highlight action that does not work?

Answer: Verify the source and target sheets, trigger configuration, selected fields, and matching field values in both views.

Q13. Why might a filter action display no results?

Answer: The selected values may not exist in the target data, the field mapping may be incorrect, or the applied filters may be too restrictive.

Q14. How can filter actions improve dashboard usability?

Answer: They allow users to explore related data by selecting marks directly, reducing the need for separate reports or numerous filter controls.

Q15. What should be tested before publishing a dashboard?

Answer: Test source and target configuration, triggers, field mappings, clearing behavior, multiple selections, performance, permissions, and the published dashboard experience.

16. Practice Exercises

1. Create a filter action that filters sales by region.
2. Create a filter action that filters product details by category.
3. Configure a filter action using Selected Fields.
4. Change the clearing-selection behavior and compare the results.
5. Create a highlight action that emphasizes selected categories in a product chart.
6. Build a highlight action that uses a shared field between two worksheets.
7. Compare the same dashboard with a filter action and a highlight action.
8. Use a filter action and a highlight action together and test their behavior.
9. Write a short explanation of when each action is appropriate for a business dashboard.
10. Test the finished dashboard and document any problems and solutions.

17. Quick Revision Checklist

• Understand the definition and purpose of filter actions.
• Understand the definition and purpose of highlight actions.
• Know the differences between filtering and highlighting.
• Identify source sheets and target sheets.
• Understand Hover, Select, and Menu triggers.
• Know the difference between All Fields and Selected Fields.
• Configure and test clearing-selection behavior.
• Create an interactive dashboard with multiple worksheets.
• Troubleshoot incorrect mappings and unexpected results.
• Apply usability and performance best practices.

18. Conclusion

Filter Actions and Highlight Actions are essential features for creating interactive Tableau dashboards. Filter actions help users focus on relevant records, while highlight actions emphasize related marks and preserve the surrounding context for comparison.

Choosing the correct action, configuring appropriate source and target worksheets, selecting suitable fields, and testing the dashboard thoroughly will help you build effective visual analytics for sales, finance, marketing, education, logistics, and other business domains.

19. Official Tableau Learning Resources

• Official Tableau Filter Actions Documentation
• Official Tableau Highlight Actions Documentation
• Create Advanced Highlight Actions
• Tableau Actions and Dashboards
• Tableau Dashboard Learning Resources

20. Tableau Training and Course Demo

Explore Tableau training resources to learn more about data visualization, dashboard development, filter actions, highlight actions, and interactive business reporting.

Explore Tableau Training

Register for a Tableau Course Demo