Using Power View in Excel 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 141

Tip You can use the Grid Height and Grid Width buttons on the Layout tab to select the
number of rows and columns for the multiples grid. If the overall size of the visualiza-
tion cannot display the entire grid, you can use a scroll bar to view the remaining rows or
columns.

Interacting with a scatter chart
You can explore relationships between two numeric values when you use a scatter chart. Further-
more, you can animate the scatter chart by adding a field to the Play Axis. For example, you can use
a data field in the Play Axis to observe changes in the chart over periods of time. At minimum, you
use two values in the scatter chart: one for the horizontal or X axis, and the other for the vertical or
Y axis. You must also define a field to use as a category (in the Details box of the layout section) for
grouping and aggregating the X and Y values. With this minimal layout, your scatter chart will display
points representing coordinates for each distinct value for the category, as shown in Figure 5-22, but
the chart does not label each coordinate. You can hover the mouse pointer over the point to see the
details displayed as a ToolTip, which is also shown in Figure 5-22.

FIGURE 5-22 You can use a scatter chart to display values as coordinates on the X and Y axis.

For deeper analysis, you can add a third value to create a bubble chart for which the size of the
bubble reflects the proportional difference in values for each category. Another option, whether you
use a scatter chart or a bubble chart, is the use of color to group related categories. And finally, you
can add a field to the Play Axis area of the layout section to add animation to the visualization. Let's
set up a scatter chart to see the relationship between sales amounts, year-to-date sales, and margins
for sales territories over time.

Add another Power View sheet to your report and then create a table using the fol-
lowing fields from the Sales Territory table in the model: SalesTerritoryCountry and
SalesTerritoryGroup .

1.

2. Add the following fields from the Reseller Sales table: Reseller Sales YTD and SalesAmount .
The Reseller Sales YTD column is empty because the table does not yet contain a date-time
data type that this calculation requires to return a value.