Database Reference
In-Depth Information
they will be surfaced here. As you see here, the fields have created a
table on the canvas, which is the starting point for any item added.
3.
Now you can change the initial table into a different visualization such
as a column chart by switching over to the Design tab in the Ribbon.
4.
You can then drag other fields into the Filter pane to the right of the can-
vas, as shown in Figure 6-6, which provides additional context-sensitive
filters on the report.
5.
Additional fields you add to the canvas that you want as slicers can be
enabled by selecting them and then clicking slicer in the Ribbon. Simple!
Creating your First Simple Power View report
Now you dive deeper and build a financial-style report step by step. Because
financials are not always eye-grabbing, you can add some visualizations to it
to spice it up.
1.
Open Excel 2013, if it isn't open already, and go to the Data tab. Make
sure you are in a worksheet in the Excel workbook, because if you are
in a Power View report the items will be greyed out. Select Existing
Connections, and then select the connection file that you created previ-
ously in this chapter in the section “Creating a Data Source,” and refer to
that section if you still need to create the data source connection. This
will display the Data Import dialog box where you will then want to select
the Power View Report option, and click OK, as shown in Figure 6-5.
2.
Now you create your first table in Power View. In the Power View Fields
list, select InternetSales
a
OrderQuantity and SalesAmount. In the
Field Well click on the drop-down arrow next to OrderQuantity and
select Sum. Also select Geography
a
EnglishCountryRegionName and
StateProvinceName. This process creates your first table on the canvas.
Figure 6-7 shows an example.
3.
Using filters is easy in this new interface. Between the main part of the
canvas and the field list is the Filters Area. Drag fields from the list into
the Filters pane such as SalesTerritory
a
SalesTerritoryGroup and Date
a
CalendarYear. Make selections from these two fields in the Filters pane
and watch as the data changes in the table. Experiment with dates,
numeric values, and regular text columns to see the different types of
sliding filters and check box lists you can get.
