1336
Part IX: Business Intelligence
- On the top-right corner, click the Create Power View Report icon to launch
PowerView, as shown in Figure 59-7.
FIGURE 59-7
Create Power View Report option.- Power View opens as a blank canvas.
- Click inside the title area. Type a title, for example, Picnic Items Analysis.
- From the fi eld list on the right, expand Quantities.
- Drag the measure named Sum of Qty Consumed 2 to the left side of the Power View
layout section. The Sum of Qty Consumed 2 measure displays as a table. - From the fi eld list on the right, expand Date and drag MonthName next to the Sum
of Qty Consumed 2 measure inside the same table. Make sure MonthName is placed
inside the same table and not on a separate table. - Click Column under the Design menu option of the Table Tools. The table changes to
a Column Chart. - Move the chart to the right. Expand the chart so that it occupies approximately 3/4
of the layout section’s width below the title, as shown in Figure 59-8. - From the fi eld list on the right, expand Items, and drag Category Drawing outside
and to the left of the Column Chart.
c59.indd 1336c59.indd 1336 7/31/2012 10:37:07 AM7/31/2012 10:37:07 AM
http://www.it-ebooks.info