Last Modified Date: 05 Jan 2021
AnswerThe 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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials