Last modified date: 28 Feb 2024
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
- Select Analysis > Create Calculated Field
- In the Calculated Field dialogue box that opens, do the following, then click OK:
- Name the calculated field. In this example, the calculated field is named "Reset Label"
- In the formula field, create a calculation similar to the following:
"Reset Filters"
- Drag [Reset Label] to Text on the Marks card
- In the top grey bar, change the dropdown from Standard to Fit Width
- To add a background colour, navigate to Format > Shading…
- In the Format Shading panel, under Default for Worksheet, select a colour in the dropdown
- To change font colour, navigate to Format > Font…
- In the Format Font panel, under Default for Worksheet, select a colour in the dropdown
- Add the "Reset Button" worksheet to the dashboard
- Right-click the "Reset Button" worksheet in the dashboard and untick Title
Create the Action Filter to Make the Button Work
- Navigate to Dashboard > Actions…
- In the Actions dialog, click Add Action > Filter…
- In the Add Filter Action dialog, do the following:
- For Source Sheets, tick only Reset Button
- For Run action on, choose Select
- For Target Sheets, tick all worksheets that have filters that should be resettable
- For Clearing the selection will, select Show all values
- For Target Filters, choose Selected Fields
- Click Add Filter…
- In the Add Filter dialog, pick a dimension whose filter should be resettable and click OK
- 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.
- Click OK twice to close all dialogs.
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.
Discuss this article... Feedback Forum
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
Related links
Results 1-3 of 866
Trending Articles
Results 1-3 of 866