Loading

Specifying a Default Filter When Action is Cleared

Julkaisupäivä: Feb 23, 2026
Tehtävä
How to default to a specified dimension member when an action filter is cleared.
Vaiheet
  1. Create a calculated field that filters to the specified dimension member when no filters are applied.
  2. For example, to set "Washington" as the default filter when the action is cleared, place the following calculation on the Filters Shelf and keep only TRUE:
MIN({FIXED: COUNTD([State])}) <> MIN({EXCLUDE [State],[City]: COUNTD([State])})
OR
MIN([State])="Washington"
 
In the attached sample workbook, click on the State of California to show the data on the bottom sheet, and then click anywhere outside of the USA map on top sheet to clear the filter. The focus will be back to the State of Washington set as the default. 
Lisäresurssit
  • The table-scoped FIXED LOD ignores the filter, so it always returns the unfiltered amount of members
  • The EXCLUDE LOD does not ignore the filter, so it returns the filtered amount of members
  • If those values are equal, nothing is filtered
  • If nothing is filtered, only keep records where [State]="Washington"
  Tableau's Order of Operations
Filter Actions
Knowledge-artikkelin numero

001453802

Liitteet

Default Filter When Cleared.twbx

516 KB

 
Ladataan
Salesforce Help | Article