Creating Filters with Actions on Dashboards
Last Modified Date: 21 Mar 2013
The advantage of a filter action is that it can filter across multiple relational data sources at the same time. Multi-dimensional data sources (cubes) may require additional steps.
Create a control worksheet
This article uses the Sample - Superstore data source and assumes that you have already created a dashboard.
Step 1Create a new worksheet.
Drag a dimension to the Rows shelf and to Text. For example, use the Category field.
Right-click the dimension and clear the selection for Show Header to hide the dimension header. Hiding the header gets rid of the ABC placeholder on the dashboard.
Select options on the Format menu and format the text to encourage users to interact with it. In this example, the categories are formatted to appear as hyperlinks.
Right-click the blank area of the worksheet and select Title.
Double-click the Title bar to open the Edit Title dialog box so you can give the worksheet an actionable title. For example, the title shown below is "Click a Sub-Category."
Create a filter action on the dashboard
In Tableau Desktop 7.0 and later, select Dashboard > New Dashboard.
In Tableau Desktop 6.1 and earlier, select Edit > New Dashboard.
Drag the control sheet you just created from the Dashboard pane to the dashboard. Make sure to position the sheet so others see it and know they should click there first.
Select the control worksheet in the dashboard so that it is highlighted.
On the dashboard view menu, select Use as Filter.
Now any selection on your control sheet modifies other views in the dashboard. Try it out in the view below by selecting a sub-category in the control sheet.
This type of filter action affects the underlying worksheets in Tableau Desktop. When the dashboard is published to Tableau Server or Tableau Public, the action applies only to the dashboard; the other worksheets are not changed.Alternate Search Terms: actions, filter, dash, report