top of page
Writer's pictureSimon Beaumont

Applying filters - Selected sheets with a related data source

As Tableau has evolved the number of options for applying filters across worksheets and data sources has increased. It is common place for people to apply a filter to Worksheets:


- All using related data sources

- All using this data source

- Selected Worksheets

- Only this Worksheet


What may not be widely known is that you can mix and match the 'apply a filter' options to create more custom filter settings.


For example in a recent Workbook within my workplace we successfully used this approach to apply 2 different filters to Worksheets 'All using related data sources' and then changed the apply option to 'Selected Worksheets'. This enabled filter 1 to work across all related data sources but only for Worksheets A, C and D and filter 2 to also work across all related data sources but only for Worksheets B and E. By doing this we changed the setting for that filter to 'Selected sheets with a related data source'; an option which is not one of the standard four available within the 'Apply to' menu.

172 views0 comments

Comments


bottom of page