1341
Chapter 59: Creating and Deploying Power View Reports
59
FIGURE 59-11
Horizontal multiples.To create an interactive Bubble chart, we by creating a scatter chart by following the
next steps:- Open the PicnicItemAnalysis Power View Report.
- Create a new view.
- Click inside the title area. Type a title, for example, Attendance & Consumption
Analysis. - From the fi eld list on the right, expand Quantities.
- Drag the measure named Qty Served YTD to the layout section. The Qty Served YTD
measure displays as a table. - Drag the Sum of Attendees measure next to Qty Served YTD inside the same table. Make
sure Sum of Attendees is placed inside the same table and not on a separate table. - Expand the visualizations options on the Ribbon menu under the Design menu
option of the Table Tools. Click Scatter. The table changes to a Scatter Chart. - Drag the Sum of Qty Consumed 2 measure to the Size box below the fi eld list.
- Expand Items and drag the Name to Details box below the fi eld list.
- Drag Category to the Color box below the fi eld list.
- Expand Date and drag MonthName to the Play Axis box below the fi eld list.
- Resize the chart to occupy all the area below the title, as shown in Figure 59-12.
c59.indd 1341c59.indd 1341 7/31/2012 10:37:08 AM7/31/2012 10:37:08 AM
http://www.it-ebooks.info