Database Reference
In-Depth Information
Enhancing your Power View reports
Now that you've created your first simple report, let's add some pizazz to your
reports by adding images.
1.
Create a new Power View Report in Excel connecting to the data model
provided with this chapter. If you need any help refer to the first step in
the previous exercise.
Let's add some images to a new version of the report we created in the
previous exercise. In the next couple of steps, you build a report with
even more interaction.
2.
Create a table on the report using Geography
a
StateProvinceName
and InternetSales
a
OrderQuantity and SalesAmount from the field
list. Make sure to select Sum from the drop-down arrow next to
OrderQuantity in the Field Well just like in the previous exercise. Then
Select ProductCategory
a
CategoryImage and drag it into the Tile
By section in the Field Well, as shown in Figure 6-9. When you add
CategoryImage to the Field Well you will probably receive a Security
Warning message above the worksheet. You will need to click the
Enable Content button to allow for the images to be displayed. The
images are referencing URL locations on the Internet, so you will also
need an Internet connection for these to display properly.
FIguRe 6-9
The Field Well
showing Tile By CategoryImage
3.
Next, drag the following fields onto the canvas to use as slicers:
uu
Geography
a
EnglishCountryRegionName
uu
Date
a
CalendarYear
uu
SalesTerritory
a
SalesTerritoryRegion
uu
Customer
a
EnglishEducation
uu
Customer
a
EnglishOccupation
For the CalendarYear table you may need to change the setting in the
Field Well to Do Not Summarize (if it is set to Sum) so that you will be able
to change this to a slicer.
4.
Click each one of the fields you just added on the report, select the
Design tab in the Ribbon, and then click Slicer. This will turn each of
these fields (tables) into a live filter with no additional work on your part
to hook them up or build relationships to the other items on the report.
Figure 6-10 shows the finished example after the items have been rear-
ranged, sized, and with selections made in the slicers.
