Last Modified Date: 22 Mar 2017
ResolutionThe attached example workbook uses the sample data set Superstore to demonstrate the following instructions.
Option 1: Apply the same filter to all source worksheetsTo ensure that all source worksheets have the same filter applied, follow the steps below:
- Open each worksheet of the dashboard that contain the desired filter.
- Ensure the desired filter is correctly configured. In the attached workbook for example: the Segment dimension is set to Exclude Home office.
- Right-click the filter and select Apply to worksheets > Selected worksheets.
Option 2: Apply filters that should never be overwritten to the data sourceInstead of applying the filter to all worksheets, add the filter as a data source filter. If only some worksheets should be filtered, then it is possible to duplicate the data source, and then add the data source filter to one of the data sources. In the attached workbook, the following steps were performed:
- Right-click "Orders (Sample - Superstore)" in the data pane and select Duplicate
- Right-click "Orders (Sample - Superstore) (copy)" in the data pane and select Edit Data Source Filters…
- Click Add.
- Select the dimension you wish to filter and click OK.
- Keep/Exclude the desired data and click OK.
- Click OK.
- Recreate any worksheets that should be filtered with the duplicate data source
CauseCurrently there is not a "Clearing the selection" option that will revert all worksheets back to their independent filter selections.
Additional InformationFor more information about what the current options "Leave the filter", "Show all values", and "Exclude all values" do, please see Step 7 in the Product Help guide: Filter Actions.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials