KNOWLEDGE BASE

Specifying a Default Filter When Action is Cleared


Published: 08 Jun 2018
Last Modified Date: 11 Jun 2018

Question

How to default to a specified dimension member when an action filter is cleared

Environment

Tableau Desktop

Answer

  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({COUNTD([State])}) <> MIN({EXCLUDE [State],[City]: COUNTD([State])})
OR
MIN([State])="Washington"

Additional Information

  • 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"
Did this article resolve the issue?