Creating Dashboards with Power View - Microsoft Business Intelligence Tools for Excel Analysts - page 95

Convert your chart into a panel of charts. You can use the VERTICAL MULTIPLES or the
HORIZONTAL MULTIPLES drop zone to turn the original chart into a panel of charts (simply drag the
data field into any one of the drop zones). Figure 5-8 shows how the original chart has been repli-
cated to show a separate chart for each data item in the On_Site_Management field.
Figure 5-8: Dragging the On_Site_Management field to the VERTICAL MULTIPLES drop zone creates
a panel of charts.
Add drill-down capabilities. Drag a new data field to the AXIS drop zone. Figure 5-9 shows the Gen_
State field dragged to the AXIS drop zone. Initially, it seems as though nothing has happened. But in
the background, Power View has layered in the newly selected field as a new category axis.
After you add your new field to the AXIS drop zone, double-click any data point in the chart. The
chart automatically drills into the next level. In Figure 5-10, Gen_State (generator state) was added
to the AXIS drop zone, so the chart drills down to show the breakdown by state for the selected
data point.
Click the arrow icon to drill back up.
Tip
You can add as many charts as you want to your Power View canvas. All components in the Power
View window are automatically linked so that they respond to one another. For example, Figure 5-11
shows two charts on the same Power View canvas. Clicking the pie slice for Arkansas (AR) dynamically
recolors the bar chart so that it highlights the portion of the bar with the Arkansas data — all without
any extra work from you!