From what I understand you are looking to create global dashboard actions that will manipulate multiple sheets on the dashboard.
I would suggest to read through these two articles Creating Filters with Actions on Dashboards | Tableau Software and Filtering Across Multiple Data Sources | Tableau Software .
Each of these articles present a few different methods on the use of filters that will interact with multiple worksheets on a dashboard in Tableau Desktop.
3 of 3 people found this helpful
Building off of Patrick's suggestion I created a sample workbook that uses 4 action filters:
- Show Drilldown 1
- Hide Drilldown 1
- Show Drilldown 2
- Hide Drilldown 2
In my example Bar chart 1 filters Drilldown 1 on [Region], and Bar chart 2 filters Drilldown 2 on [Category]. The "Show Drilldown 1" and "Show Drilldown 2" filters are action filters that use only one bar chart as the source sheet, and the corresponding drill down as the target sheet.
The Hide actions are a little more complicated. Essentially when a value in Bar chart 1 is selected we want to filter Drill down 2 to show no data. We can accomplish that by only filtering on a selected filter that matches the value from Bar chart 1 (which is [Region]) with a field that does not contain any of the same values. See the image below for how I set up my action filter:
In this example I matched [Region] with [Category], so that when the "Show Drilldown 2" action is run it will overwrite this filter.
The last thing you need to do to completely hide the drilldown worksheet that has been filtered to show no data is place both worksheets in a layout container and hide the titles. Layout containers are designed so that any worksheets within a layout container automatically resize to fill the space (worksheets within a horizontal layout container will automatically resize their width). Check out the Product Help Quick Start: Layout Containers for more information.
I hope this answers your question!