Last Modified Date: 19 Mar 2024
Environment
- Tableau Desktop
Answer
The following example uses Superstore sample data.- Create the original worksheet to show the ranking of Sales by Sub-Category.
- Create a new worksheet For filter to show the quick filter of Sub-Category.
- Duplicate the data field Sub-Category that will be used as a filter.
- Add Sub-Category (copy) to the filter, and select the values that should be always selected.
- Check Exclude and click OK.
- Add data field Sub-Category to the filter, select all values, click OK.
- Right click Sub-Category in the Filters card, select Show Filter.
- Create a new dashboard.
- Add worksheet original to the dashboard.
- Add worksheet For filter to the dashboard, hide the title of this worksheet.
- Put worksheet For filter in a place that won't affect the view.
- Right click the Sub-Category filter in the dashboard, select Only Relevant Values.
- Right click the Sub-Category filter in the dashboard, select Apply to Worksheets > Selected Worksheets, check original, click OK.
- Right click the Sub-Category filter in the dashboard, select Customize, uncheck the Show "All" Value
- This is to avoid that the default selected values will be unchecked when "All" is unchecked.
- Go to worksheet original, show filter for Sub-Category.
- Check all values in Sub-Category.
- Uncheck at least one value that does not belongs the default selected values.
- This is to avoid that the action of uncheck "All" is triggered.
- Go to the dashboard, check the values that are unchecked in step 17.
Additional Information
You can download the sample workbook and the video from the Attachments on the right for more details.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