Master filtering allows the elements in one dashboard item in a dashboard to update the data in another dashboard item on the same dashboard. Master filters that have been applied can be reset.
Master filtering is only available if the dashboard has been designed to include it. See Accessing Dashboards.
For example, a bar graph showing total sales counts by sales representative can be used to update a pie chart showing sales counts by state for the selected sales representative.
Dashboard items that can be used as master filters show the master filter icon at the right end of the caption for the dashboard item.
The icon is shaded lighter if the master filter is not currently applied. The icon is not visible if the dashboard item is configured to hide the dashboard item caption.
To apply the master filter, click one of the elements in the dashboard item. All related dashboard items in the dashboard are updated to reflect only the data for the element clicked, unless a dashboard item has been configured to be excluded from master filtering.
For example, the pie chart and pivot table in this dashboard are updated to reflect the specific sales representative when the data bar for that sale representative is clicked in the bar chart:
The master filter can be removed in one of the following ways:
-
Click the master filter icon at the right end of the caption for the dashboard item, if it is available.
-
Click Clear All Filters in the View ribbon group to remove all interactive filters on the dashboard.
-
Right-click the dashboard item and select Clear All Filters from the right-click menu to remove all interactive filters on the dashboard.