Loading

Specifying a Default Filter When Action is Cleared

Дата публикации: Feb 23, 2026
Задача
How to default to a specified dimension member when an action filter is cleared.
Действия
  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. 
Дополнительные ресурсы
  • 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
Номер статьи базы знаний

001453802

Вложения

Default Filter When Cleared.twbx

516 KB

 
Загрузка
Salesforce Help | Article