Dashboard Actions and Navigation in Tableau

Topic: Tableau Dashboard Actions and Navigation

Objective: Learn how to create interactive Tableau dashboards using filter actions, highlight actions, URL actions, sheet navigation, and navigation objects so users can explore data and move between views easily.

Course Link: Explore Tableau Training

Demo Link: Register for a Tableau Course Demo

1. Introduction to Dashboard Actions

Dashboard actions are interactive features in Tableau that allow users to perform an operation by clicking, hovering over, or selecting a data mark. They connect different worksheets and help users investigate related information without manually changing multiple filters or opening separate views.

For example, a sales dashboard may contain a map, a regional sales chart, and a customer table. When a user clicks a region on the map, the sales chart and customer table can update to display information for that region.

Why Dashboard Actions Are Important

• Make dashboards interactive and easier to explore.
• Connect related worksheets and visualizations.
• Help users investigate detailed information from summary charts.
• Reduce the need for numerous visible filters.
• Support data exploration and business decision-making.
• Provide links to related dashboards, websites, and external resources.

Example

Suppose a company has sales data for Maharashtra, Gujarat, Karnataka, and Delhi. A user selects Maharashtra in a regional chart. A filter action can update the product chart, profit chart, and customer table to show only Maharashtra's data.

2. Understanding Tableau Dashboard Actions

Tableau provides several types of actions. Each action has a different purpose and can be configured according to the dashboard's requirements.

Important: The actions available in a particular workflow can vary with the Tableau version and authoring environment.

3. Understanding Source Sheets and Target Sheets

Most dashboard actions use a source and a target. Understanding these terms is essential before creating an action.

Source Sheet

The source sheet is the worksheet where the user performs the interaction. For example, a user clicks a bar representing the West region in a sales chart.

Target Sheet

The target sheet is the worksheet affected by the action. For example, the product chart and customer table update to show information related to the West region.

Example Workflow

1. Create a regional sales bar chart.
2. Create a product sales chart.
3. Create a customer details table.
4. Add all three worksheets to a dashboard.
5. Configure the regional sales chart as the source.
6. Choose the product chart and customer table as targets.
7. Set up a filter action that passes the selected region to the target worksheets.
8. Test the dashboard by selecting different regions.

Result: Users can explore the sales performance of individual regions without navigating away from the dashboard.

4. Types of Action Triggers

Tableau allows an action to run in response to different user interactions. The trigger determines how the user activates the action.

Choosing the Right Trigger

• Use Hover when immediate visual feedback is helpful and accidental interactions are acceptable.
• Use Select when the user should deliberately choose a data point.
• Use Menu when the dashboard should expose an explicit action link instead of triggering an operation immediately.

5. Filter Actions in Tableau

A filter action passes values from a selected mark in one worksheet to another worksheet, filtering the target view to show related records. It is especially useful for interactive drill-down analysis.

Example

A sales dashboard contains a map of states and a chart of product sales. Selecting Gujarat on the map filters the product chart to show product sales for Gujarat.

Steps to Create a Filter Action

1. Open a Tableau workbook containing the required worksheets.
2. Create a dashboard and add the source and target worksheets.
3. Select Dashboard > Actions.
4. Click Add Action > Filter.
5. Enter a descriptive name, such as Filter Product Sales by Region.
6. Choose the source worksheet that will trigger the action.
7. Select the trigger, such as Select or Hover.
8. Choose the target worksheets that should respond.
9. Configure how selected fields are passed to the target worksheets.
10. Choose what happens when the selection is cleared.
11. Click OK and test the action.

Clearing a Filter Action

Practical tip: Use Show All Values for dashboards where users should easily return to the complete analysis after exploring one category.

Use as Filter Shortcut

For a quick setup, select a worksheet on the dashboard and click its Use as Filter icon, if available. Tableau uses that view to filter other views on the dashboard. Use a formal filter action when you need more control over the source, targets, trigger, and clearing behavior.

6. Highlight Actions in Tableau

A highlight action emphasizes marks that match a selected value while dimming unrelated marks. Unlike a filter action, highlighting usually preserves the surrounding data in the visualization, allowing users to compare the selected group with the rest of the data.

Example

A dashboard contains a category chart and a product scatter plot. Hovering over the Furniture category highlights the Furniture products in the scatter plot while leaving other products visible.

Steps to Create a Highlight Action

1. Open a dashboard containing the source and target worksheets.
2. Select Dashboard > Actions.
3. Click Add Action > Highlight.
4. Give the action a descriptive name, such as Highlight Selected Category.
5. Choose the source worksheet.
6. Choose the trigger, such as Hover or Select.
7. Select the target worksheets.
8. Choose the fields used to match marks, such as Category or Region.
9. Confirm the settings and test the action.

Highlight Matching Options

• All Fields: Matches marks using all relevant fields in the source and target views.
• Selected Fields: Matches marks using specific fields chosen for the action.
• Dates and Times: Matches marks using the relevant date or time fields.

Filter Action vs Highlight Action

7. Go to Sheet Actions

A Go to Sheet action lets users navigate to another worksheet, dashboard, or story within the same Tableau workbook through a selected mark or a tooltip menu item.

Example

A user selects a region in a sales summary chart and opens a detailed dashboard containing product performance, monthly trends, and customer information.

Steps to Create a Go to Sheet Action

1. Open the dashboard that contains the source worksheet.
2. Select Dashboard > Actions.
3. Click Add Action > Go to Sheet.
4. Enter a descriptive action name, such as Open Regional Sales Details.
5. Select the source worksheet.
6. Choose the trigger, usually Select or Menu.
7. Choose the destination worksheet, dashboard, or story.
8. Configure the selection behavior where applicable, including single-selection behavior if users should navigate only after selecting one mark.
9. Click OK and test the navigation.

Benefits of Go to Sheet Actions

• Connect summary views to detailed analysis.
• Reduce the need for separate navigation controls in some workflows.
• Support guided analysis from overview to detail.
• Help users explore related dashboards without leaving the workbook.

Important: A Go to Sheet action is initiated through interaction with a mark or action menu. For direct navigation between dashboards without selecting a data mark, consider using a Navigation object.

8. Navigation Objects in Tableau

A Navigation object is a dashboard object that provides a direct way for users to move to another dashboard or sheet. It is useful for building dashboard menus, home pages, and multi-page analytical applications.

Example

A business intelligence workbook can contain a home dashboard with navigation options for Sales Overview, Product Analysis, Customer Insights, and Regional Performance.

Steps to Add a Navigation Object

1. Open the dashboard where the navigation control should appear.
2. In the Dashboard pane, locate the Objects section.
3. Drag a Navigation object onto the dashboard, if supported in your Tableau authoring version.
4. Choose the destination sheet or dashboard.
5. Customize the displayed button or navigation text.
6. Adjust the layout, size, alignment, and placement.
7. Repeat for additional destinations.
8. Test every navigation control in the dashboard or published workbook.

Navigation Object vs Go to Sheet Action

9. URL Actions in Tableau

A URL action opens an external web page or another supported resource based on a user interaction. It can also pass field values from a visualization into a URL, allowing the destination to show information related to the selected record.

Example

A dashboard contains product sales. Selecting a product and choosing a URL action can open that product's detail page on the company's website.

Steps to Create a URL Action

1. Open the workbook and select Dashboard > Actions.
2. Click Add Action > Go to URL.
3. Give the action a descriptive name, such as Open Product Details.
4. Select the source worksheet.
5. Choose the trigger, such as Menu or Select.
6. Enter the destination URL beginning with https:// where appropriate.
7. Use the Insert menu to include supported field values as dynamic URL parameters when needed.
8. Choose whether the URL opens in a browser tab or a dashboard Web Page object, where supported.
9. Test the URL action and verify that the destination is correct.

Dynamic URL Example

Imagine a visualization contains a field called ProductID. A web application might accept a URL in the following pattern:

https://example.com/products?id=<ProductID>

Note: This is an illustrative pattern. In Tableau's URL action editor, insert the field through the provided Insert menu rather than assuming that manually typed angle-bracket text will be recognized in every context. The destination website must also support the parameter.

URL Action Best Practices

• Use complete URLs, including the appropriate protocol.
• Give each action a meaningful name.
• Verify that field values are available in the source view.
• Test special characters and URL encoding.
• Avoid including confidential data in URLs.
• Confirm that users are permitted to access the destination website.

10. Change Parameter Actions

A parameter action lets a user change a parameter by interacting with a visualization. Parameters can then drive calculations, reference lines, selected measures, or other analytical behavior.

Example

A dashboard allows users to select Sales, Profit, or Quantity from a chart. The selection updates a parameter that controls which measure appears in a related visualization.

Basic Workflow

1. Create a parameter with suitable data type and allowed values.
2. Create a calculated field that uses the parameter.
3. Build a worksheet that displays the fields users will interact with.
4. Open Dashboard > Actions.
5. Add a Change Parameter action, if available in the authoring environment.
6. Select the source sheet and trigger.
7. Choose the parameter to update and the source field that supplies its value.
8. Configure clearing behavior where available.
9. Test the action using different marks.

Parameter actions are especially helpful when building dynamic dashboards and what-if analysis tools. Ensure that the parameter's data type is compatible with the field supplying its value.

11. Change Set Values Actions

A set action allows a user to interact with data marks to change which members belong to a set. Sets can then be used in calculations, colors, labels, and comparisons.

Example

A customer dashboard lets users select a group of customers. The selected customers form an interactive set, allowing the business to compare their sales against the remaining customer base.

General Workflow

1. Create a set from a dimension, such as Customer Name.
2. Create a worksheet containing the dimension members.
3. Build a calculation or visualization that uses set membership.
4. Open the dashboard action settings.
5. Add a Change Set Values action.
6. Select the source worksheet, target set, and trigger.
7. Configure how selections update the set.
8. Test the interaction and verify that dependent views respond correctly.

Set actions are useful for interactive segmentation, selected-versus-other comparisons, and custom group analysis.

12. Combining Actions in One Dashboard

A dashboard can combine multiple actions to create a more complete analytical experience. For example, selecting a region can filter a product chart, highlight the corresponding data in a map, and provide a navigation option to open a detail dashboard.

Example Configuration

Important Configuration Considerations

• Use descriptive action names so users understand the available choices.
• Choose source and target worksheets carefully.
• Prevent unintended interactions by excluding irrelevant target sheets when configuring actions.
• Use clear filter-reset behavior.
• Test actions together because one interaction can influence the result of another.
• Keep the dashboard focused instead of adding unnecessary actions.

13. Understanding Action Order

When several actions are triggered by the same interaction, Tableau processes action types in a defined order. The documented order is:

1. Parameter actions
2. Set actions
3. Filter actions
4. Go to Sheet actions
5. Highlight actions
6. URL actions

Within each action type, Tableau processes actions alphabetically by action name. Understanding the order can help diagnose unexpected results when a dashboard combines several actions.

Practical advice: Give actions clear names and test workflows that combine filtering, highlighting, and navigation. Do not assume that multiple actions will behave as a single simultaneous operation.

14. Designing Effective Dashboard Navigation

Good navigation helps users understand where they are, what they can explore, and how to return to a previous view. Dashboard navigation should support the user's analytical task rather than distract from it.

Recommended Practices

• Create a home dashboard: Provide a starting point for important reports.
• Use descriptive labels: Prefer names such as Sales Overview and Customer Details over generic labels such as Page 1.
• Group related dashboards: Organize views by business topic or user role.
• Provide a clear return path: Make it easy to return to the overview or main menu.
• Keep navigation consistent: Use the same label style and placement across related dashboards.
• Make controls discoverable: Explain how users can select marks, clear selections, and navigate.
• Test the published version: Check navigation in the environment where the dashboard will be used.

15. Practical Project: Interactive Sales Dashboard

Project objective: Create an interactive sales dashboard that lets business users filter sales by region, highlight product categories, navigate to a detailed dashboard, and open an external product page.

Sample Data Fields

Step 1: Connect to the Data

1. Open Tableau Desktop or a supported Tableau authoring environment.
2. Connect to a sample sales dataset or your own sales file.
3. Verify that date fields, dimensions, and numeric measures are assigned appropriate data types.
4. Review missing values and inconsistent categories.

Step 2: Create the Worksheets

• Worksheet 1 – Sales by Region: Create a bar chart using Region and SUM(Sales).
• Worksheet 2 – Sales by Category: Create a bar chart using Category and SUM(Sales).
• Worksheet 3 – Monthly Sales Trend: Plot Order Date against SUM(Sales).
• Worksheet 4 – Customer Details: Create a table containing Customer Name, Sales, and Profit.
• Worksheet 5 – Product Details: Create a table or chart with Product Name, ProductID, Sales, and Profit.

Step 3: Build the Overview Dashboard

1. Create a new dashboard.
2. Add the regional sales chart, category chart, and monthly trend.
3. Add suitable titles, legends, and summary information.
4. Arrange the worksheets in a logical reading order.
5. Add the customer details view if the layout remains clear.

Step 4: Add a Regional Filter Action

1. Open Dashboard > Actions.
2. Add a Filter action named Filter Dashboard by Region.
3. Choose Sales by Region as the source.
4. Choose the category chart, monthly trend, and customer details as targets.
5. Set the trigger to Select.
6. Set the clearing behavior to Show All Values.
7. Test the action by selecting different regions.

Step 5: Add a Category Highlight Action

1. Add a Highlight action.
2. Choose Sales by Category as the source.
3. Select the monthly trend or another suitable target view.
4. Match using the appropriate fields available in both views.
5. Choose Hover if immediate highlighting is appropriate.
6. Test whether the intended marks are highlighted.

Step 6: Create a Detailed Dashboard

1. Create another dashboard named Regional Sales Details.
2. Add detailed product and customer views.
3. Add relevant context, such as selected region and sales performance.
4. Return to the overview dashboard and configure a Go to Sheet action from the regional chart, if contextual navigation is required.
5. Alternatively, add a Navigation object to provide a direct link to the detailed dashboard.
6. Test both the navigation destination and the expected filter behavior.

Step 7: Add a Product URL Action

1. Open the dashboard action settings.
2. Add a Go to URL action from the product view.
3. Use a trusted product-detail URL pattern supported by your website.
4. Insert the ProductID field through Tableau's URL editor if the website accepts a product identifier as a URL parameter.
5. Choose an appropriate target, such as a browser tab.
6. Test with several products and verify that the correct pages open.

Step 8: Validate the Project

• Confirm that each filter action updates only the intended views.
• Confirm that highlight actions emphasize the expected marks.
• Verify that all navigation controls reach the correct destinations.
• Check that URL actions use valid and safe destinations.
• Check that clearing selections behaves as expected.
• Test the dashboard using different selections and filter combinations.
• Publish the dashboard if required and test it in the target environment.

Expected Result

The completed dashboard allows users to move from an overall sales summary to regional and product-level analysis. Filter and highlight actions make comparisons easier, while navigation and URL actions provide access to detailed reports and related product information.

16. Common Problems and Troubleshooting

17. Dashboard Actions Best Practices

• Use actions to answer a clear business question.
• Prefer a small number of meaningful interactions over many competing controls.
• Use filter actions for focused analysis and highlight actions for comparisons.
• Use Go to Sheet actions for data-driven navigation.
• Use Navigation objects for direct dashboard-to-dashboard movement.
• Use URL actions only with trusted and appropriate destinations.
• Give actions descriptive names that explain their purpose.
• Configure source and target worksheets intentionally.
• Choose suitable trigger types for the audience and use case.
• Test action combinations, clearing behavior, and navigation paths.
• Ensure labels and instructions are understandable to non-technical users.
• Check accessibility, readability, and performance before publishing.

18. Interview Questions and Answers

Q1. What are dashboard actions in Tableau?

Answer: Dashboard actions are interactive features that respond to user interactions with visualizations. They can filter data, highlight marks, change parameters or sets, open URLs, and navigate to other sheets.

Q2. What is a filter action?

Answer: A filter action passes selected values from a source worksheet to one or more target worksheets, restricting the target views to related data.

Q3. What is the difference between a filter action and a highlight action?

Answer: A filter action generally removes unrelated records from the target view, while a highlight action emphasizes related marks and keeps other marks available for comparison.

Q4. What is a source sheet?

Answer: The source sheet is the worksheet where the user performs the interaction that triggers an action.

Q5. What is a target sheet?

Answer: The target sheet is the worksheet that responds to the action, for example by filtering or highlighting its data.

Q6. What are the common action triggers?

Answer: Hover, Select, and Menu. Hover runs an action when the pointer moves over a mark, Select runs it when a mark is selected, and Menu runs it when a user chooses an action from a mark's tooltip menu.

Q7. What is a Go to Sheet action?

Answer: It allows users to navigate to another worksheet, dashboard, or story within a workbook through an interaction with a source mark or action menu.

Q8. What is a Navigation object?

Answer: It is a dashboard control that allows users to navigate directly to a specified destination, making it useful for dashboard menus and home pages.

Q9. What is a URL action?

Answer: A URL action opens an external web resource and can pass supported field values as parameters to show related information.

Q10. When should you use a highlight action instead of a filter action?

Answer: Use a highlight action when users need to identify related marks while comparing them with the rest of the data. Use a filter action when users need to focus on a subset of records.

Q11. What is a parameter action?

Answer: A parameter action changes a parameter through user interaction with a visualization. The parameter can then drive calculations, reference lines, or dynamic analysis.

Q12. What is a set action?

Answer: A set action updates membership in a set based on user selections, supporting interactive grouping and selected-versus-other comparisons.

Q13. How do you create a dashboard action?

Answer: Open the dashboard, choose Dashboard > Actions, select Add Action, choose the required action type, and configure its name, source, trigger, targets, and other relevant settings.

Q14. Why might a filter action fail?

Answer: Common causes include an incorrect source or target, incompatible or unmatched fields, unexpected clearing behavior, or action configuration that does not match the intended interaction.

Q15. What is the purpose of dashboard navigation?

Answer: Navigation helps users move through related views in a logical sequence, such as moving from an overview to a detailed report or returning to a home dashboard.

19. Practice Exercises

1. Create a dashboard with sales by region and sales by category. Add a filter action so selecting a region updates the category chart.
2. Create a highlight action that emphasizes a selected product category in another worksheet.
3. Build a regional overview dashboard and a regional details dashboard. Connect them using a Go to Sheet action.
4. Add a Navigation object that returns users to the overview dashboard.
5. Create a URL action that opens a trusted external product-detail page.
6. Configure a filter action to show all values after the source selection is cleared.
7. Build a dashboard with two source views and test how their actions interact.
8. Create a parameter action that changes the selected measure in a visualization.
9. Create a set action that allows users to select customers and compare their sales with other customers.
10. Publish or share the completed dashboard and test the actions in the intended viewing environment.

20. Quick Revision Checklist

• Understand the purpose of Tableau dashboard actions.
• Identify source sheets and target sheets.
• Understand Hover, Select, and Menu triggers.
• Know how to create filter actions and configure clearing behavior.
• Understand how highlight actions differ from filter actions.
• Know how Go to Sheet actions provide contextual navigation.
• Understand when to use Navigation objects.
• Know how URL actions connect visualizations to external resources.
• Understand the basic purpose of parameter and set actions.
• Know why action order and configuration matter.
• Test action combinations, navigation paths, and performance.

21. Conclusion

Dashboard Actions and Navigation are essential Tableau features for building interactive and user-friendly analytical applications. Filter actions help users focus on relevant data, highlight actions support comparisons, URL actions connect reports to external resources, and Go to Sheet actions connect related views. Navigation objects provide a direct route between dashboards. By choosing appropriate actions, configuring source and target worksheets carefully, and testing the complete user journey, you can create dashboards that make data exploration easier and more effective.

Further Learning Resources

• Tableau Actions Documentation
• Tableau Actions and Dashboards
• Tableau Filter Actions
• Tableau URL Actions
• Tableau Dashboard Learning Resources

Explore More: Explore Tableau Training

Book a Demo: Register for a Tableau Course Demo