Microsoft Office Tutorials and References
In Depth Information
Creating a Standard Slicer
With minimal effort, you can integrate your slicers nicely into your dashboard layout. Figure 16-15,
illustrates two slicers and a pivot chart working together as a cohesive dashboard component.
Figure 16-15: With a little formatting, slicers can be made to adopt the look and feel of your overall dashboard.
Controlling multiple pivot tables
Another advantage you gain with slicers is that each slicer can be tied to more than one pivot table.
That is to say, any filter you apply to your slicer can be applied to multiple pivot tables.
To connect your slicer to more than one pivot table, simply right-click the slicer and select Report
Connections. This activates the Report Connections dialog box shown in Figure 16-16. Place a check
next to any pivot table that you want to filter using the current slicer.
Figure 16-16: Choose the pivot tables that will be filtered by this slicer.
At this point, any filter you apply to the slicer will be applied to all the connected pivot tables.
Controlling the filter state of multiple pivot tables is a powerful feature, especially in dashboards that
run on multiple pivot tables.