1340
Part IX: Business Intelligence
FIGURE 59-10
Ver tical multiples.- Drag the Sum of Qty Served measure next to Sum of Leftovers inside the same
table. Make sure Sum of Qty Served is placed inside the same table and not on a
separate table. - Under the Design menu option of the Table Tools, expand the visualizations options
on the Ribbon menu. Click Clustered Bar. The table changes to a Clustered Bar
Chart. - From the fi eld list on the right, expand Date.
- Drag MonthName to the Horizontal Multiples box below the fi eld list section.
- From the fi eld list on the right, expand Items.
- Drag Distributors to the Axis box below the fi eld list section.
- Click Grid on the Layout menu option on the Ribbon menu. Change the chart to a
3 x 1 chart. - Change the Legend to show Legend at Top.
- Resize the chart to occupy all the area below the title, as shown in Figure 59-11.
- Save the Power View report.
Working with Animated Scatter and Bubble Charts
Scatter charts and its variation, the Bubble chart, are great visualizations to see the rela-
tionships between data series. Combined with a date dimension, Power View supports ani-
mated playback of these relationships through a timeline.c59.indd 1340c59.indd 1340 7/31/2012 10:37:08 AM7/31/2012 10:37:08 AM
http://www.it-ebooks.info