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

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.

Important: Dashboard Actions connect different views and enable interactive data exploration. They help users discover relationships between data points without creating separate dashboards for every analytical requirement.

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.
Source Sheet Sales Chart User Trigger Select Region Action Filter Data Target Details User interaction controls the information displayed in the target view.
Figure 1: General workflow of a Tableau dashboard action.

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

  1. Open the Tableau dashboard.
  2. Add the source and target worksheets.
  3. Select Dashboard from the top menu.
  4. Choose Actions.
  5. Click Add Action.
  6. Select Filter.
  7. Enter a meaningful action name.
  8. Select the source worksheet.
  9. Select the target worksheet.
  10. Choose the trigger event.
  11. Configure the clearing selection behavior.
  12. 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.
Business Example: A regional sales manager selects the North region to analyze its product performance. The target chart automatically updates to show only the selected region's sales.

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

  1. Open the dashboard.
  2. Add the source and target worksheets.
  3. Open Dashboard → Actions.
  4. Click Add Action.
  5. Select Highlight.
  6. Enter the action name.
  7. Choose the source worksheet.
  8. Choose the target worksheet.
  9. Select the required trigger event.
  10. Configure the highlighting fields.
  11. 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.

Important: Highlight Actions are useful when users need to compare selected information with the remaining data without filtering the other values out of the visualization.

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.
Filter Action Highlight Action Sales by Region North South East West Only selected region displayed Sales by Region North South East West All regions remain visible Illustrative comparison of filtering and highlighting behavior
Figure 2: Filter Actions restrict data, while Highlight Actions emphasize selected data.

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

  1. Open the Tableau dashboard.
  2. Navigate to Dashboard → Actions.
  3. Click Add Action.
  4. Select URL.
  5. Enter a meaningful action name.
  6. Select the source worksheet.
  7. Choose the trigger event: Select, Hover, or Menu.
  8. Enter the destination URL.
  9. Insert supported field values when a dynamic URL is required.
  10. Configure the URL opening behavior if available.
  11. 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.
Example: A dashboard contains an employee ID field. A URL Action can use the selected employee ID to open the relevant employee record in an authorized external system.
Security Note: Use trusted destinations and avoid exposing confidential information through URL parameters. Verify that users have appropriate access to external resources.

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

  1. Open the source dashboard.
  2. Select Dashboard → Actions.
  3. Click Add Action.
  4. Select Go to Sheet.
  5. Enter an action name.
  6. Select the source worksheet.
  7. Choose the trigger event.
  8. Select the destination sheet.
  9. Configure navigation options if available.
  10. Save and test the action.
Use Case: Go to Sheet Actions are helpful for creating multi-level reporting experiences, such as moving from a company overview to department-level analysis.

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

  1. Create a parameter in the Tableau workbook.
  2. Use the parameter in a calculated field or visualization.
  3. Open the dashboard.
  4. Navigate to Dashboard → Actions.
  5. Click Add Action.
  6. Select Change Parameter.
  7. Choose the source worksheet.
  8. Select the target parameter.
  9. Choose the source field whose value should update the parameter.
  10. Configure aggregation and clearing behavior as required.
  11. 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

  1. Create a set from a dimension in the Data pane.
  2. Add a visualization that contains the set dimension.
  3. Open the dashboard.
  4. Select Dashboard → Actions.
  5. Click Add Action.
  6. Select Change Set Values.
  7. Choose the source worksheet.
  8. Select the target set.
  9. Configure the set action behavior.
  10. 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.
Design Tip: Avoid configuring too many actions on hover. Unintended interactions can make a dashboard confusing. Use selection or menu triggers when users need more deliberate control.

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

  1. Open the Tableau dashboard.
  2. Select Dashboard from the menu.
  3. Choose Actions.
  4. Review the list of configured actions.
  5. Select an action that needs modification.
  6. Click Edit to change its configuration.
  7. Use Add Action to create another action.
  8. Remove actions that are no longer required.
  9. 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.
Sales Dashboard Sales by Region Filter Action Sales by Category Highlight Action Product Details URL Action Interactive Analysis Explore related business information
Figure 3: Example of multiple actions working together in a sales dashboard.

Implementation Steps

  1. Connect to the sales dataset.
  2. Create the four required worksheets.
  3. Build the main sales dashboard.
  4. Create a Filter Action between regional and category worksheets.
  5. Create a Highlight Action for category analysis.
  6. Create a URL Action for product details.
  7. Create a Go to Sheet Action for regional navigation.
  8. Configure the appropriate trigger events.
  9. Test every action independently.
  10. 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

  1. Create a Sales by Region worksheet.
  2. Create a Sales by Category worksheet.
  3. Create a Monthly Sales Trend worksheet.
  4. Create a Product Details worksheet.
  5. Combine all worksheets into one dashboard.
  6. Configure a Filter Action for regional analysis.
  7. Configure a Highlight Action for category analysis.
  8. Configure a URL Action for product information.
  9. Configure a Go to Sheet Action for detailed analysis.
  10. Test every action using different data selections.
Expected Result: An interactive sales dashboard where users can select regions, highlight product categories, open product information, and navigate to detailed reports.

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.