Last Modified Date: 27 Jun 2018
ResolutionUse Sheets to filter a dual axis map on a dashboard. Using the Sample - Superstore data source, create two action filters for the dual axis chart: one for states, and one for postal codes.
- Go to Dashboard > Actions
- In the menu, click Add Action > Filter.
- In the Edit filter action menu, select only the sheet that contains the dual axis map as the Source Sheet.
- Run action on should be set to Select.
- In the Target Sheet section, all sheets should be selected for the dashboard.
- For Target Filters, choose Selected Fields.
- Click the Add Filter button.
- In the add filter menu, select postal code in both drop down menus.
- Click OK.
- Click OK again in the edit filter action menu.
- Repeat the above steps. However, in the Target Filters menu, select state instead of postal code.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials