KNOWLEDGE BASE

Clearing All Filters and Filter Actions on a Dashboard with One Click


Published: 03 Oct 2016
Last Modified Date: 28 Feb 2024

Question

How to reset Filter Actions and/or filters on a dashboard to include all values with one click.

Environment

  • Tableau Desktop
  • Tableau Server
  • Filter Actions
  • Filters

Answer

Option 1: Press [Esc]
Press the [Esc] key to reset Filter Actions (this option will not work for filters). For more information, see Keyboard Shortcuts
Option 2: Click the Revert Button on Published Views
On published views, click the Revert button to revert to the view at the time it was published, or if applicable the state the Custom View was saved in.
Option 3: Create a button to reset all filters to include all values
The directions below use the sample data set Superstore. The workbook attached in the right-hand pane demonstrates these directions for a dimension filter, a date filter, and a Filter Action.
Build the Reset Button Worksheet
  1. Select Analysis > Create Calculated Field
  2. In the Calculated Field dialog box that opens, do the following, and then click OK:
    1. Name the calculated field. In this example, the calculated field is named "Reset Label"
    2. In the formula field, create a calculation similar to the following:
      "Reset Filters"
  3. Drag [Reset Label] to Text on the Marks card
  4. In the top gray bar, change the dropdown from Standard to Fit Width
  5. To add a background color, navigate to Format > Shading…
  6. In the Format Shading panel, under Default for Worksheet, select a color in the dropdown
  7. To change font color, navigate to Format > Font…
  8. In the Format Font panel, under Default for Worksheet, select a color in the dropdown
  9. Add the "Reset Button" worksheet to the dashboard
  10. Right-click the "Reset Button" worksheet in the dashboard and uncheck Title

Create the Action Filter to Make the Button Work

  1. Navigate to Dashboard > Actions…
  2. In the Actions dialog, click Add Action > Filter…
  3. In the Add Filter Action dialog, do the following:
    1. For Source Sheets, check only Reset Button
    2. For Run action on, choose Select
    3. For Target Sheets, check all worksheets that have filters that should be resettable
    4. For Clearing the selection will, select Show all values
    5. For Target Filters, choose Selected Fields
    6. Click Add Filter…
    7. In the Add Filter dialog, pick a dimension whose filter should be resettable and click OK
    8. Repeat the above two steps for all filters that should reset when the button is pressed.
      Note: there will be a "Missing fields on Reset Button" warning. This warning will not affect the solution and can be ignored.
  4. Click OK twice to close all dialogs.
Option 4: Use an Extension to Revert to a Preset
Extensions are third party add-ons that add functionality to Tableau. To set up extensions, please see Use Dashboard Extensions. You may need to reach out to your administrator for Tableau Server or Tableau Cloud to enable the extension online. For issues with specific extensions please reach out to the party that wrote the extension; This information is available in the right-hand pane of the extension page under Support. 
  1. Download the Filter Bookmarks extension
  2. Add the Filter Bookmarks extension to a dashboard


 

Additional Information

Notes on Option 3
  • To reset Filter Actions set to All Fields for Target Filters, add all dimensions on the source sheet of the resettable Action Filter to the Action Filter for the Reset Button
  • The Reset Button will clear the affects of other Action Filters on their target worksheets, but will not unselect the marks in the source sheets
  • The "Reset Button" cannot be filtered! If there is a filter applied to All Using This Datasource or All Using Related Datasources, then this will also filter the "Reset Button" worksheet.
  • The Reset Button will not reset wildcard filters or continuous filters.
To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: Reset All Action Filters on Dashboard



 
Did this article resolve the issue?