Database Reference
In-Depth Information
Once you have your model set up, creating a Power View
report is simple: Go the Insert tab in the Excel Ribbon and
click Power View. Start by dragging the Value field from
FaceOECDPopulation to the Fields box, Geo Regions from
DimCountry to Tiles, and then CountryName to Fields. You
will need to resize the chart and should see something
similar to Figure 13-31.
Drag Value from FactOECDPopulation to the whitespace
next to the table, which creates a new table, and change
it to a bar chart. By dragging CountryName to the Axis field, the bar chart will
now become interactive, as seen in Figure 13-32.
F I g u R e 13-31 A tiled Power View report
F I g u R e 13-32 Filtering a Power View report
This chart is still meaningless as it is simply a sum of all the different statistics.
Start by clicking the CHART button on the Filters section, and filtering this
chart to show just the GDP per capita. You will need to drag Metric to the
Filter section and select the metric, as shown in Figure 13-33.
Search WWH ::




Custom Search