Database Reference
In-Depth Information
How to do it...
The steps to visualize the analysis with Power View and Power Maps follow.
Creating Power View visualization
In this recipe, the same example as that in the
Creating the data model with PowerPivot
re-
cipe is used. The following steps will show you how to create a Power View sheet from the
data model created in the PowerPivot recipe:
1. Open the Excel sheet created in the
Creating the data model with PowerPivot
re-
cipe.
2. On the
Insert
tab, click on
Power View
.
A new sheet is created in the Excel workbook to configure Power View.
3. Expand
PerformanceDataAllView
under
Power View Fields
(on the right-hand
side) and check
∑ Day
.
4. In the
File
tab in the ribbon area, click on
Other Chart
and select
Line
.
5. Click on
Day
, drag it from the
VALUES
area, and drop it into the
AXIS
area.
6. Click on
NewColumn.Path
under
PerformanceDataAllView
and drag it into
AXIS
.
7. Click on
∑ SampleValue
and drag it into
VALUES
, as shown in the following
screenshot: