When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, withal, yous might want to apply the filter to other worksheets in the workbook.

You lot tin can select specific worksheets to utilise the filter to or apply information technology globally to all worksheets that use the same data source or related data sources. For example, you might have a filter that merely includes a specific region or product of interest. Rather than adding this filter every time you create a new worksheet, you can just create the filter once and so apply it to multiple worksheets.

This option applies the filter to all worksheets that use related data sources as their primary information source.

To apply a filter to all worksheets using a related primary data source:

  • On the Filters shelf, right-click the field and select Utilise to Worksheets > All Using Related Data Sources.

Filters that use this selection are global beyond the workbook.

Filters that employ to all related data sources are marked with an icon. The filter is automatically created on whatever existing worksheets, and on whatever new worksheets you create that use a related data source.

Whatsoever changes you brand to the filter affects all of those worksheets.

Apply filters to all worksheets that employ the current primary data source

This choice applies the filter to all worksheets that apply the current worksheet's main data source equally their master data source.

To apply a filter to all worksheets using the current primary data source:

  • On the Filters shelf, right-click the field and select Use to Worksheets > All Using This Data Source.

Filters that use this option are global across the workbook.

Filters that utilise to all worksheets are marked with a information source icon . The filter is automatically created on any new worksheets you create later you elevate a field to the view.

Whatever changes you brand to the filter affects all of those worksheets.

Note: If you are blending multiple data sources in a view, All Using This Data Source adds the filter to all sheets that use the same master data source in the electric current sail. The sheets that the filter gets applied to is not based on the filter field's data source.

Utilize filters to select worksheets

This option opens a dialog box where y'all tin can select from a list of worksheets that use the same data source or related data sources.

To apply a filter to select worksheets:

  • On the Filters shelf, right-click the field and select Utilise to Worksheets > Selected Worksheets.

  • In the Apply Filter to Worksheets dialog box, select the worksheets that you want to apply the filter. If any of the sheets already contain a filter on the aforementioned field, the dialog box will provide details about the filter.

    If you select the canvass, the electric current filter will override whatsoever existing filter selections.

Filters that apply to a choice of worksheets are marked with the worksheet icon . Any changes you brand to the filter affect all of the selected worksheets.

Apply filters to the current worksheet only

This option simply applies to the electric current worksheet. This selection is selected by default when yous create new filters. Filters that are local to the current worksheet are shown without any boosted icons.

To apply a filter to the current worksheet just:

  • On the Filters shelf, correct-click the field and select Employ to Worksheets > Only This Worksheet.

If you lot employ a filter to all worksheets or selected worksheets and and so change the setting to apply the filter to simply the electric current worksheet, the filters are not removed from all other worksheets. Rather, the filters are disconnected and they are all fabricated local to their respective worksheets. You can go to each worksheet and remove the filter or modify selections.

Filter all worksheets on a dashboard

This option applies the filter to all worksheets in the dashboard that use the same information source or related data sources as their primary information source.

To filter all worksheets on a dashboard:

  • In a dashboard, click the driblet-down menu on a filter card and select Apply to Worksheets > Selected worksheets.

  • In the Utilize Filter to Worksheets dialog box, click All on dashboard, and and then click OK.

Note: In previous versions of Tableau Desktop, the All Using This Data Source option was called Make Global and the But This Worksheet choice was Make Local.