Last Modified Date: 12 Jul 2023
Environment
- Tableau Desktop
Answer
- Create a calculated field that filters to the specified dimension member when no filters are applied.
- 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"
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.
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"
Filter Actions
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials