Yes, you should be able to do this with dashboard actions. See attached as an example of selecting on the bar graph to filter sub-category sheet and 1.1 and 2.1, then selecting on sub-category to hide/show 1.1 or 2.1.
There is a combination of actions from the bar graph in the example that you would build for the map sheet:
1. Filter all sheets to the selected category from sheet
2. Hide sheet 2.1 when a category is selected from sheet
Then a combination of actions on the second level sub-category list in the example that you would build for the tree map sheet:
1. Filter all sheets by sub-category from sheet
2. Hide sheet 1.1 when a sub-category is selected from sheet
3. Show sheet 2.1 when a sub-category is selected from sheet
There are four calculated fields to use and map in the actions:
Sheet Show = TRUE (so when we map the fields in the action, it will keep results displayed)
Sheet Hide = FALSE (so when we map the fields in the action, it will cause no results to be returned in the sheet and hide it)
Sheet 1.1 = TRUE
Sheet 2.1 = TRUE
filtering between sheets.twb 311.9 KB
Hi Aaron, can you attached the dataset for the example your sharing please!!
Working out a solution to fit your scenario is a bit tricky because you are blending two data sources. I created two fields called Zero and One which are used to hide and clear the sheets. The idea in hiding the sheets is to pass 'conflicting information' (zero <> one) via the action filters to the sheets.
You will also need to create data relationships before a filter in a sheet from one data source can affect the other. Also, I've made most of the filters to apply to several worksheets. Notice also that I added most of the fields to the Detail marks card. This will make those fields available to both source and target sheets. You need to recreate the actions (both in the dashboard and worksheets) exactly as contained in the attached workbook for this solution to work.
Hope this helps.
Hide and Show Sheets_OO_v10.2.twbx 644.3 KB
1 of 1 people found this helpful
You're welcome Monse. Glad it helped.
Could you please mark my answer as correct?
Have an excelent day!! =D