Microsoft Office Tutorials and References
In Depth Information
Using Slicers as Form Controls
Figure 16-22: You can highjack pivot slicers and use them as more attractive Form controls for models not built
on pivot tables.
If you skipped Chapter 12, you may want to visit it now in order to better understand
the data modeling and setup demonstrated in this example.
To build this basic model, follow these steps:
1. Create a simple table that holds the names you want for your controls, along with
some index numbering. In this case, the table contains three rows under a field called
Each row contains a metric name and index number for each metric (Income, Expense,
2. Using this simple table, create a pivot table (see Figure 16-23).
Figure 16-23: Create a simple table that holds the names for your controls along with some index
numbering; then using that table, create a pivot table.
3. Place your cursor anywhere inside the newly created pivot table, select the Analyze tab, and
then click the Insert Slicer icon. In the Insert Slicer dialog box, create a slicer for the Metric
At this point, you have a slicer with the three metric names.
4. Right-click the slicer and choose Slicer Settings to activate the Slicer Settings dialog box.