Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Interactive Filtering in Tableau

Learn how to create interactive Tableau worksheets and dashboards using filter cards, quick filters, dashboard filter actions and highlight actions. Build reports that allow users to explore business data dynamically.

1. Introduction to Interactive Filtering

Interactive Filtering in Tableau allows users to dynamically control the information displayed in a worksheet or dashboard. Instead of viewing only a fixed report, users can select categories, regions, dates or other values to explore specific information.

Interactive filters make dashboards more flexible and useful for business analysis. For example, a sales manager can select a particular region and immediately examine its sales performance.

Benefits of Interactive Filtering

  • Allows users to explore data without modifying the original dataset.
  • Provides dynamic control over dashboard information.
  • Helps compare business performance across categories.
  • Improves dashboard usability and flexibility.
  • Supports self-service data analysis.
  • Helps users focus on relevant information.
Filters Region: West Category Interactive Dashboard User selections update dashboard results.
Conceptual flow of filter selections and interactive dashboard results.

2. Understanding Quick Filters

Quick Filters allow users to display filter controls directly in a worksheet. They provide an easy way to select or remove values without repeatedly opening the filter configuration dialog.

In modern Tableau versions, these controls are commonly displayed as filter cards. The available control style depends on the field type and filter configuration.

Common Filter Card Controls

  • Single Value List
  • Single Value Dropdown
  • Multiple Values List
  • Multiple Values Dropdown
  • Multiple Values Custom List
  • Wildcard Match
  • Range of Values for supported numeric or date fields
Region Filter Select Region East West North South Filtered Results East West Selected members
Example of a multiple-value filter card.

Steps to Display a Quick Filter

  1. Open a Tableau worksheet.
  2. Drag a dimension or measure to the Filters shelf.
  3. Choose the required filter values.
  4. Apply the filter.
  5. Open the filter field's menu on the Filters shelf.
  6. Select Show Filter.
  7. The filter card appears in the worksheet.
  8. Choose a suitable filter card style from its menu.
Tip: Choose a filter card control that matches the number of available values. Dropdowns are useful for long lists, while visible lists work well when users need to compare a small number of categories.

3. Single Value and Multiple Value Filters

Tableau filter cards can be configured to allow users to select either one value or multiple values. The selection type depends on the field and the chosen filter card presentation.

Single Value Filter

A Single Value Filter allows the user to select one member at a time. When another member is selected, the previous selection is replaced.

Example: A manager selects only the West region to view its sales performance.

Multiple Value Filter

A Multiple Value Filter allows users to select more than one member simultaneously.

Example: A manager selects both West and East regions to compare their sales performance.

Feature Single Value Multiple Value
Selection One member at a time Multiple members
Typical Use Focused analysis Comparison and exploration
Example West region West and East regions
Control Style Single-value list or dropdown Multiple-value list or dropdown
Single Value West East Multiple Values West East Filter selection controls which members are included.
Conceptual comparison of single-value and multiple-value filter selection.

4. Applying Filters to Multiple Worksheets

A dashboard or workbook may contain multiple worksheets that use the same data source. Tableau allows users to apply a filter to multiple worksheets so that related visualizations respond to the same selection.

This is useful when a dashboard contains a sales chart, profit chart and regional performance table. Selecting a region can update all related worksheets.

Steps to Apply a Filter to Multiple Worksheets

  1. Open a worksheet containing the required filter.
  2. Display the filter card.
  3. Open the filter card's menu.
  4. Choose Apply to Worksheets.
  5. Select the required worksheets or use the relevant data-source scope option.
  6. Open the other worksheets and verify the results.

Common Apply-to-Worksheets Options

Option Purpose
Only This Worksheet Applies the filter only to the current worksheet.
Selected Worksheets Applies the filter to selected worksheets.
All Using This Data Source Applies the filter to worksheets using the same data source.
All Using Related Data Sources Can apply filtering across related data sources when the workbook configuration supports it.
Important: The available worksheet scope options depend on the workbook and data source configuration. Verify that the target worksheets use compatible fields and data sources.

5. Dashboard Filter Actions

Dashboard Filter Actions allow one worksheet to filter another worksheet when a user selects a mark or data point. They create a more interactive dashboard experience.

For example, clicking a region in a sales map can filter a product sales chart to display only the products belonging to that region.

Source Worksheet West Region East Region Filter Action Target Worksheet Target view updates based on selection.
A selection in a source worksheet filters a target worksheet through a Dashboard Filter Action.

Steps to Create a Dashboard Filter Action

  1. Create the source and target worksheets.
  2. Open a Tableau dashboard.
  3. Add both worksheets to the dashboard.
  4. Open the Dashboard menu.
  5. Select Actions.
  6. Choose Add Action and then Filter.
  7. Choose the source worksheet.
  8. Select the target worksheet.
  9. Configure the run action on selection, hover or menu as required.
  10. Configure the target filter fields and clearing behavior.
  11. Save the action and test it by selecting a mark.
Example: When a user selects West in the source region chart, the target product chart can display only West region products.

6. Highlight Actions in Tableau

Highlight Actions allow users to emphasize related data points across dashboard worksheets without removing the other marks from the view.

Unlike a Filter Action, which restricts the displayed data, a Highlight Action visually emphasizes matching marks while other marks remain visible.

Highlight Action Example Product A Product B Product C Product D Product E Product F Selected data is emphasized; other marks remain visible.
Highlighting emphasizes selected related data points.

Steps to Create a Highlight Action

  1. Open a dashboard containing related worksheets.
  2. Open Dashboard and select Actions.
  3. Choose Add Action and then Highlight.
  4. Select the source worksheet.
  5. Select the target worksheet.
  6. Configure the trigger method.
  7. Choose the matching fields or selected fields as required.
  8. Save the action and test it using a data point.

Filter Action vs Highlight Action

Feature Filter Action Highlight Action
Primary Purpose Restricts displayed data. Emphasizes related marks.
Other Marks Unmatched data may be removed from the target view. Other marks remain visible.
Typical Use Detailed analysis of selected data. Comparing related data points.
Dashboard Interaction Filters target worksheets. Highlights related target marks.

7. Use a Worksheet as a Filter

Tableau provides a simple dashboard interaction that allows users to use one worksheet as a filter for other worksheets.

When this feature is enabled, selecting a mark in the source worksheet filters the related information displayed in other applicable dashboard worksheets.

Steps to Use a Worksheet as a Filter

  1. Open a dashboard containing multiple worksheets.
  2. Select the worksheet that should act as the source.
  3. Locate the Use as Filter control in the worksheet toolbar.
  4. Enable the filter interaction.
  5. Select a mark in the source worksheet.
  6. Observe how the other dashboard worksheets respond.
Best Practice: Use this feature when a simple selection-based filter interaction is sufficient. Use Dashboard Actions when you need more control over source sheets, target sheets, trigger behavior and clearing options.

8. Dashboard Filter Action Configuration

Dashboard Actions provide control over how interactive selections are handled. While configuring an action, users can choose the source sheets, target sheets, trigger behavior and clearing behavior.

Configuration Description
Source Sheets Worksheets that trigger the dashboard action.
Target Sheets Worksheets that receive the action.
Run Action On Defines whether the action runs on Select, Hover or Menu.
Target Filters Defines which fields are used to match source and target data.
Clearing Selection Defines what happens when the source selection is cleared.

Common Trigger Methods

Select: Runs the action when a user selects a mark.

Hover: Runs the action when a user moves the pointer over a mark.

Menu: Makes the action available through the selected mark's menu.

9. Practical Example: Interactive Sales Dashboard

In this practical example, we will create a dashboard where users can select a region and dynamically explore sales information for that region.

Business Requirement

A company wants a sales dashboard containing:

  • Sales by Region.
  • Sales by Product Category.
  • Profit by Region.
  • Interactive Region selection.

Step 1: Create Sales by Region

  1. Connect Tableau to a sales dataset.
  2. Create a new worksheet.
  3. Drag Region to Rows.
  4. Drag Sales to Columns.
  5. Choose the required chart type.
  6. Rename the worksheet to Sales by Region.

Step 2: Create Sales by Category

  1. Create another worksheet.
  2. Drag Category to Rows.
  3. Drag Sales to Columns.
  4. Create a bar chart.
  5. Rename the worksheet to Sales by Category.

Step 3: Create Profit by Region

  1. Create another worksheet.
  2. Drag Region to Rows.
  3. Drag Profit to Columns.
  4. Create a suitable visualization.
  5. Rename the worksheet to Profit by Region.

Step 4: Build the Dashboard

  1. Create a new dashboard.
  2. Add Sales by Region.
  3. Add Sales by Category.
  4. Add Profit by Region.
  5. Arrange the worksheets in a clear layout.

Step 5: Add Interactive Filtering

  1. Select Sales by Region in the dashboard.
  2. Enable Use as Filter or create a Dashboard Filter Action.
  3. Configure the required target worksheets.
  4. Save the dashboard.
  5. Select a region and verify the updated charts.
  6. Clear the selection and verify the dashboard reset behavior.
Interactive Sales Dashboard Sales by Region East West North South Sales by Category Profit by Region Regional Performance Details Selected Region: West Category and Profit views update based on selection.
Conceptual layout of an interactive Tableau sales dashboard.
Expected Result: Selecting West in the Sales by Region worksheet updates the related target visualizations to show information associated with that selection.

10. Common Interactive Filtering Problems

Problem Possible Reason Solution
Filter card is not visible Show Filter has not been enabled. Open the field menu on the Filters shelf and select Show Filter.
Filter does not affect another worksheet The filter is scoped only to the current worksheet. Configure Apply to Worksheets or a Dashboard Filter Action.
Dashboard action does not work Source or target worksheets may be configured incorrectly. Review the action configuration and test the source selection.
Unexpected marks disappear A Filter Action may be removing unmatched marks. Review clearing selection behavior and target filter settings.
Highlight does not match expected data Matching fields may not be configured correctly. Review the highlight action's field configuration.
Dashboard becomes slow Many filters and complex actions may increase processing work. Reduce unnecessary filters and optimize the workbook.

11. Best Practices for Interactive Filtering

  • Use clear and meaningful filter names.
  • Choose filter card styles based on the number of available values.
  • Use single-value filters when users need one selection at a time.
  • Use multiple-value filters when comparisons are required.
  • Apply filters to multiple worksheets only when needed.
  • Use Filter Actions for restricting target worksheet data.
  • Use Highlight Actions when other marks should remain visible.
  • Test dashboard actions before publishing.
  • Provide a clear way for users to reset selections.
  • Avoid adding too many interactive controls to one dashboard.

Summary

Interactive Filtering in Tableau allows users to explore information dynamically using filter cards, single-value and multiple-value selections, worksheet filters and dashboard actions.

Dashboard Filter Actions restrict target worksheet data based on selections, while Highlight Actions emphasize related marks without removing the other marks from the view.

By combining these features, users can create flexible, interactive dashboards that support business analysis and self-service reporting.