PivotTable Fundamentals - Microsoft Business Intelligence Tools for Excel Analysts - page 33

Figure 2-22: Select the dimensions you want filtered using slicers.
To select multiple values, press the Ctrl key while selecting the filters.
Tip
To clear the filtering on a slicer, simply click the Clear Filter icon on the target slicer (see Figure 2-23).
Figure 2-23: Clearing the filters on a slicer.
Formatting slicers
If you're using slicers in a dashboard, you'll want to do some formatting to make sure your slicers
match the theme and layout of your dashboard. Here are a few common formatting adjustments you
can make to your slicers.
Size and placement
A slicer behaves like a standard Excel shape object in that you can move it around and adjust its size
by clicking it and dragging its position points. Or right-click the slicer and select Size and Properties.