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.
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
Steps to Display a Quick Filter
- Open a Tableau worksheet.
- Drag a dimension or measure to the Filters shelf.
- Choose the required filter values.
- Apply the filter.
- Open the filter field's menu on the Filters shelf.
- Select Show Filter.
- The filter card appears in the worksheet.
- Choose a suitable filter card style from its menu.
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 |
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
- Open a worksheet containing the required filter.
- Display the filter card.
- Open the filter card's menu.
- Choose Apply to Worksheets.
- Select the required worksheets or use the relevant data-source scope option.
- 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. |
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.
Steps to Create a Dashboard Filter Action
- Create the source and target worksheets.
- Open a Tableau dashboard.
- Add both worksheets to the dashboard.
- Open the Dashboard menu.
- Select Actions.
- Choose Add Action and then Filter.
- Choose the source worksheet.
- Select the target worksheet.
- Configure the run action on selection, hover or menu as required.
- Configure the target filter fields and clearing behavior.
- Save the action and test it by selecting a mark.
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.
Steps to Create a Highlight Action
- Open a dashboard containing related worksheets.
- Open Dashboard and select Actions.
- Choose Add Action and then Highlight.
- Select the source worksheet.
- Select the target worksheet.
- Configure the trigger method.
- Choose the matching fields or selected fields as required.
- 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
- Open a dashboard containing multiple worksheets.
- Select the worksheet that should act as the source.
- Locate the Use as Filter control in the worksheet toolbar.
- Enable the filter interaction.
- Select a mark in the source worksheet.
- Observe how the other dashboard worksheets respond.
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
- Connect Tableau to a sales dataset.
- Create a new worksheet.
- Drag Region to Rows.
- Drag Sales to Columns.
- Choose the required chart type.
- Rename the worksheet to Sales by Region.
Step 2: Create Sales by Category
- Create another worksheet.
- Drag Category to Rows.
- Drag Sales to Columns.
- Create a bar chart.
- Rename the worksheet to Sales by Category.
Step 3: Create Profit by Region
- Create another worksheet.
- Drag Region to Rows.
- Drag Profit to Columns.
- Create a suitable visualization.
- Rename the worksheet to Profit by Region.
Step 4: Build the Dashboard
- Create a new dashboard.
- Add Sales by Region.
- Add Sales by Category.
- Add Profit by Region.
- Arrange the worksheets in a clear layout.
Step 5: Add Interactive Filtering
- Select Sales by Region in the dashboard.
- Enable Use as Filter or create a Dashboard Filter Action.
- Configure the required target worksheets.
- Save the dashboard.
- Select a region and verify the updated charts.
- Clear the selection and verify the dashboard reset behavior.
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.