Filters are a good way to restrict the data displayed on a Tableau dashboard or to view the data, based on the filters selected. But if the number of filters are a lot, it becomes a pain to deselect filter values on multiple filters. In this blog, we will discuss how to reset filters in Tableau dashboards with a single click.
How to reset filters in Tableau
Create a sheet with a visualization. Select fields to be used as filters.
Create a new Reset sheet.
Create a calculation with just a text such as “Reset Filters”.
Place this calculation on Shape under Marks.
Select an appropriate shape such as an arrow which will work as a reset button.
Create a dashboard which will contain the visualization and Reset sheets. Use the floating option to adjust the objects on the dashboard.
Create a dashboard Action of type Filter. Use Reset sheet as Source and your visualization as the Target Sheet.
Specify the Target Filters by selecting the fields you want to reset.
How to reset filters in Tableau with example
1. I will first connect to Sample – Superstore.xls. This file is provided by Tableau as a sample data set.
2. From the Data pane on the left, place Region on Rows and Sales on Columns. Place Region on Colours to get distinct colours for each region.
This will create a bar chart or select one from Show Me. Name this sheet as “Bar Chart”.
3. From the Data pane, select Region, Segment and Category as your filters. Right-click on each and select Show filter. These fields will be displayed as filters on your visualization.
Filters can display Apply button too. Learn how to display Apply button on filters in Tableau.
Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.
Explore more of his work on his Amazon Author Profile.
Post a Comment