Dashboard Actions in Tableau
Learn how to make Tableau dashboards interactive using Filter Actions, Highlight Actions, URL Actions, Navigation Actions, and other dashboard interactions to explore and communicate data effectively.
1. What are Dashboard Actions?
Dashboard Actions in Tableau allow users to interact with visualizations and dynamically explore related information. Instead of simply viewing charts, users can select marks, hover over data points, or interact with dashboard elements to trigger specific operations.
For example, when a user selects a particular product category in a bar chart, another chart can automatically display sales information for that category.
Why are Dashboard Actions Important?
- Make dashboards interactive and dynamic.
- Allow users to explore detailed information.
- Connect multiple worksheets.
- Help identify relationships between data points.
- Support interactive business reporting.
- Improve the overall dashboard user experience.
2. Types of Dashboard Actions
Tableau provides several types of dashboard actions. Each action serves a different purpose and can be configured according to the dashboard's requirements.
| Action Type | Purpose | Example |
|---|---|---|
| Filter Action | Filters data in one or more target worksheets. | Select a region to display its sales details. |
| Highlight Action | Highlights related data points across views. | Highlight a selected product category. |
| URL Action | Opens a web page or external resource. | Open a product details page. |
| Go to Sheet Action | Navigates to another worksheet, dashboard, or story. | Open a detailed sales dashboard. |
| Change Parameter Action | Updates a parameter based on user interaction. | Select a measure to analyze. |
| Change Set Values Action | Updates set membership based on selected marks. | Select products for comparison. |
3. Understanding the Dashboard Action Workflow
A dashboard action generally involves a source sheet, a user interaction, and a target sheet or destination. The source provides the selected information, and the action determines what happens next.
Main Components
- Source Sheet: The worksheet where the user performs an interaction.
- Trigger: The event that starts the action.
- Action: The operation configured in Tableau.
- Target Sheet: The worksheet that receives the action.
- Clearing Selection: Defines what happens when the selection is removed.
4. Filter Actions in Tableau
Filter Actions allow users to filter information in one worksheet by interacting with another worksheet. When a user selects a mark in the source visualization, Tableau passes the selected data values to the target visualization.
Example of a Filter Action
Consider a sales dashboard containing two worksheets:
- Source: Sales by Region.
- Target: Sales by Product Category.
When the user selects the East region in the source chart, the target chart displays only product category sales related to that region.
Steps to Create a Filter Action
- Open the Tableau dashboard.
- Add the source and target worksheets.
- Select Dashboard from the top menu.
- Choose Actions.
- Click Add Action.
- Select Filter.
- Enter a meaningful action name.
- Select the source worksheet.
- Select the target worksheet.
- Choose the trigger event.
- Configure the clearing selection behavior.
- Click OK and test the dashboard.
Filter Action Trigger Options
| Trigger | Behavior |
|---|---|
| Select | Runs the action when a user selects a mark. |
| Hover | Runs the action when the pointer moves over a mark. |
| Menu | Runs the action when a user chooses the action from a menu. |
Clearing the Selection
Tableau allows you to define what happens when the user clears the selected mark in the source worksheet.
- Show All Values: Displays all available data in the target view.
- Exclude All Values: Removes the filtered data from the target view.
- Keep Filtered Values: Retains the last filtered result.
5. Highlight Actions in Tableau
Highlight Actions help users identify related data points across multiple worksheets without removing other data from the visualization.
Unlike Filter Actions, Highlight Actions emphasize selected information while keeping the remaining data visible.
Example of a Highlight Action
Imagine a dashboard containing sales by product category and monthly sales trends. When the user selects the Furniture category, the related data points are highlighted in the monthly sales visualization.
Steps to Create a Highlight Action
- Open the dashboard.
- Add the source and target worksheets.
- Open Dashboard → Actions.
- Click Add Action.
- Select Highlight.
- Enter the action name.
- Choose the source worksheet.
- Choose the target worksheet.
- Select the required trigger event.
- Configure the highlighting fields.
- Save and test the action.
Highlighting Fields
Highlight Actions can use matching fields between worksheets. For example, a Product Category field in the source worksheet can be associated with the corresponding Product Category field in the target worksheet.
6. Filter Action vs Highlight Action
Filter and Highlight Actions both respond to user interactions, but they produce different results.
| Feature | Filter Action | Highlight Action |
|---|---|---|
| Primary Purpose | Restricts displayed data. | Emphasizes related data. |
| Other Data | Non-matching data may be removed from the target view. | Other data generally remains visible. |
| Best Use | Detailed analysis of selected information. | Comparison and identification of related information. |
| Example | Display only East region sales. | Highlight East region sales among all regions. |
7. URL Actions in Tableau
URL Actions allow users to open an external web page or a specified URL based on their interaction with a dashboard.
These actions are useful when dashboard users need to access additional information outside the current Tableau visualization.
Example of a URL Action
A product sales dashboard contains product names and their performance. When a user selects a product, a URL Action can open the corresponding product information page.
Steps to Create a URL Action
- Open the Tableau dashboard.
- Navigate to Dashboard → Actions.
- Click Add Action.
- Select URL.
- Enter a meaningful action name.
- Select the source worksheet.
- Choose the trigger event: Select, Hover, or Menu.
- Enter the destination URL.
- Insert supported field values when a dynamic URL is required.
- Configure the URL opening behavior if available.
- Save and test the action.
Static and Dynamic URLs
| URL Type | Description | Example |
|---|---|---|
| Static URL | Uses the same destination for every interaction. | A company website. |
| Dynamic URL | Uses selected field values to create a destination. | A product-specific details page. |
8. Go to Sheet Actions
Go to Sheet Actions allow users to navigate from one worksheet, dashboard, or story to another within the Tableau workbook.
This feature is useful when a dashboard provides an overview and users need to open a more detailed analytical view.
Example
A sales overview dashboard displays total sales and regional performance. When the user selects a region and triggers the navigation action, Tableau opens a detailed regional sales dashboard.
Steps to Configure Go to Sheet Action
- Open the source dashboard.
- Select Dashboard → Actions.
- Click Add Action.
- Select Go to Sheet.
- Enter an action name.
- Select the source worksheet.
- Choose the trigger event.
- Select the destination sheet.
- Configure navigation options if available.
- Save and test the action.
9. Change Parameter Actions
Parameter Actions allow users to update a Tableau parameter through interactions with a visualization. Parameters can then control calculations, reference lines, filters, and other analytical elements.
Example
A sales dashboard contains a parameter named Selected Measure. Users can select a measure such as Sales, Profit, or Quantity from a visualization. The parameter updates based on their selection, and the related chart changes accordingly.
Steps to Create a Parameter Action
- Create a parameter in the Tableau workbook.
- Use the parameter in a calculated field or visualization.
- Open the dashboard.
- Navigate to Dashboard → Actions.
- Click Add Action.
- Select Change Parameter.
- Choose the source worksheet.
- Select the target parameter.
- Choose the source field whose value should update the parameter.
- Configure aggregation and clearing behavior as required.
- Save and test the action.
Common Applications
- Dynamic measure selection.
- What-if analysis.
- Dynamic reference values.
- Interactive comparison of business metrics.
- Custom analytical controls.
10. Change Set Values Actions
Set Actions allow users to dynamically update the values contained in a Tableau set based on their interaction with a visualization.
A set is a custom subset of data members that can be used for comparison, segmentation, and advanced analytical calculations.
Example
A company wants to compare selected products against all other products. Users select products in a chart, and a Set Action updates the selected product set.
Steps to Configure a Set Action
- Create a set from a dimension in the Data pane.
- Add a visualization that contains the set dimension.
- Open the dashboard.
- Select Dashboard → Actions.
- Click Add Action.
- Select Change Set Values.
- Choose the source worksheet.
- Select the target set.
- Configure the set action behavior.
- Save and test the action.
Set Action Applications
- Compare selected products with remaining products.
- Identify top-performing customers.
- Build interactive segmentation dashboards.
- Analyze selected categories dynamically.
11. Choosing the Correct Action Trigger
Tableau allows actions to execute through different user interaction events. Choosing the correct trigger helps create a predictable and user-friendly dashboard.
| Trigger | How It Works | Suitable Scenario |
|---|---|---|
| Select | Executes when a user selects a mark. | Filtering detailed sales data. |
| Hover | Executes when the pointer moves over a mark. | Highlighting related information. |
| Menu | Executes when a user selects an action from the mark menu. | Opening a specific destination or view. |
12. Source Sheets and Target Sheets
Source and target worksheets are important when configuring dashboard actions. They determine where the interaction begins and where its result is applied.
Source Worksheet
The source worksheet is the visualization where the user performs the action. For example, a user selects a region from a regional sales chart.
Target Worksheet
The target worksheet receives the selected values or interaction. For example, a product category chart displays information related to the selected region.
Example Configuration
| Configuration | Value |
|---|---|
| Action Name | Regional Sales Filter |
| Action Type | Filter |
| Source Sheet | Sales by Region |
| Target Sheet | Sales by Category |
| Trigger | Select |
| Clearing Selection | Show All Values |
13. Managing Dashboard Actions
Tableau provides an Actions dialog where users can review, edit, add, and remove dashboard actions.
How to Manage Actions
- Open the Tableau dashboard.
- Select Dashboard from the menu.
- Choose Actions.
- Review the list of configured actions.
- Select an action that needs modification.
- Click Edit to change its configuration.
- Use Add Action to create another action.
- Remove actions that are no longer required.
- Click OK and test the dashboard.
Action Management Best Practices
- Use meaningful action names.
- Remove duplicate or unnecessary actions.
- Verify source and target worksheets.
- Use appropriate trigger events.
- Test clearing selection behavior.
- Document complex dashboard interactions.
14. Practical Example: Interactive Sales Dashboard
Consider an organization that wants to create an interactive sales dashboard. The dashboard should allow managers to explore sales information by region, category, and product.
Required Worksheets
- Sales by Region
- Sales by Category
- Monthly Sales Trend
- Product Details
Required Actions
| Action | Source | Target | Expected Result |
|---|---|---|---|
| Filter Action | Sales by Region | Sales by Category | Show selected region's category sales. |
| Highlight Action | Sales by Category | Monthly Sales Trend | Highlight the selected category. |
| URL Action | Product Details | External Product Page | Open the selected product information. |
| Go to Sheet | Sales by Region | Regional Details Dashboard | Navigate to detailed regional analysis. |
Implementation Steps
- Connect to the sales dataset.
- Create the four required worksheets.
- Build the main sales dashboard.
- Create a Filter Action between regional and category worksheets.
- Create a Highlight Action for category analysis.
- Create a URL Action for product details.
- Create a Go to Sheet Action for regional navigation.
- Configure the appropriate trigger events.
- Test every action independently.
- Review the complete dashboard experience.
15. Common Dashboard Action Problems
Dashboard actions may not behave as expected when their source, target, fields, or trigger settings are configured incorrectly. The following table describes common problems and possible solutions.
| Problem | Possible Cause | Suggested Solution |
|---|---|---|
| Filter Action does not work | Incorrect source or target worksheet. | Review the action configuration. |
| Target worksheet displays no data | Selected values do not match the target data. | Verify matching fields and clearing behavior. |
| Highlight Action does not highlight | Incorrect highlighting field mapping. | Review the source and target fields. |
| URL Action opens an incorrect page | Incorrect URL or dynamic field value. | Verify the destination URL and inserted values. |
| Navigation Action does not work | Incorrect destination sheet. | Verify the selected destination. |
| Action triggers unexpectedly | Hover trigger is configured unnecessarily. | Use Select or Menu where appropriate. |
| Selection does not reset correctly | Incorrect clearing selection behavior. | Review the clearing selection configuration. |
16. Dashboard Action Best Practices
A well-designed interactive dashboard should provide meaningful interactions without making the user experience complicated.
- Use actions only when they provide useful analytical value.
- Choose meaningful names for all actions.
- Configure source and target worksheets carefully.
- Use Select triggers for deliberate user interactions.
- Use Hover triggers only when immediate highlighting is useful.
- Test all clearing selection settings.
- Ensure URL destinations are trusted and appropriate.
- Avoid creating unnecessary duplicate actions.
- Keep dashboard navigation simple and predictable.
- Test actions with different data selections.
- Verify the dashboard after publishing.
17. Practical Exercise: Create an Interactive Dashboard
Build an interactive Tableau sales dashboard using a sample sales dataset. The dashboard should allow users to filter, highlight, navigate, and access additional product information.
Exercise Requirements
- Create a Sales by Region worksheet.
- Create a Sales by Category worksheet.
- Create a Monthly Sales Trend worksheet.
- Create a Product Details worksheet.
- Combine all worksheets into one dashboard.
- Configure a Filter Action for regional analysis.
- Configure a Highlight Action for category analysis.
- Configure a URL Action for product information.
- Configure a Go to Sheet Action for detailed analysis.
- Test every action using different data selections.
18. Dashboard Actions Quick Reference
| Action | Key Function | Typical Use |
|---|---|---|
| Filter | Passes selected values to filter target views. | Focused data analysis. |
| Highlight | Emphasizes related marks. | Data comparison. |
| URL | Opens a web destination. | External information. |
| Go to Sheet | Navigates to another workbook view. | Detailed reporting. |
| Change Parameter | Updates parameter values. | Dynamic calculations. |
| Change Set Values | Updates set membership. | Interactive segmentation. |
Summary
Tableau Dashboard Actions make dashboards interactive by allowing users to explore related information through selections, hovering, and menu interactions. In this lesson, we covered Filter Actions, Highlight Actions, URL Actions, Go to Sheet Actions, Change Parameter Actions, and Change Set Values Actions. We also explored action triggers, source and target worksheets, clearing selection behavior, action management, practical sales dashboard examples, common problems, and best practices. Filter Actions help users focus on selected data, Highlight Actions emphasize related information, URL Actions connect dashboards to external resources, and navigation actions provide access to other workbook views. Properly configured dashboard actions improve data exploration and create a more useful reporting experience.