Last Modified Date: 16 Aug 2016
When creating a dashboard, you may want to add a filter that applies to all views in the dashboard. One way to create this type of filter is to turn on a quick filter so that it appears in the dashboard, and then make it global. However, global filters also affect other worksheets and dashboards in the workbook. If you want the filter to apply only to a specific dashboard, you can create a control view and then add a filter action that goes from the control to the other views in the dashboard.
The advantage of a filter action is that it can filter across multiple relational data sources at the same time. Multidimensional data sources (cubes) may require additional steps.
Create a control view
This article uses the Superstore sample data source and assumes that you have already created a dashboard.
Create a new worksheet.
Drag a dimension to the Rows shelf and to Text. For example, use the Sub-Category field.
Right-click the dimension on the Rows shelf and clear the selection for Show Header to hide the dimension header. Hiding the header removes the left column in the view.
On the Rows shelf, right-click Sub-Category, select Font, and then click the Pane tab. Format the text to encourage users to interact with it. That is, format the items in the list to look like hyperlinks by changing the font color and adding an underline.
Right-click the blank area of the worksheet and select Title to display the 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
Go to the dashboard that you have already created.
Drag the control view 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. 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