Tableau: Multiple sheets swapping on action filter
A short explanation behind what its all about and how it works. Refer to the attached workbook ( SheetSelection_ThroughActions.twbx ): Problem Statement: Clicking on the Region section should show its corresponding State sheet, while hiding State sheets belonging to other Regions, i.e. a single click from source sheet should show destination 1 and hide destination 2. Issue: This functionality is not native to Tableau. Solution Steps: Create multiple dimension calculated fields with value 1, 2, 3 etc. depending on the number of source sheets. We have three source sheets (Central, East & South) and hence have three calculated fields. Create various dashboard action filters from each source to each destination, and pass the appropriate dimension field in the ‘Target Fields>>Selected Fields’ section. Select 'Leave the Filter' option under 'Clearing This Selection Will' section. Why/How does this fea...