In Power View in SharePoint 2013 and in Excel 2013, you can quickly create a variety of data visualizations, from tables and matrices to bar, column, and bubble charts, and sets of multiple charts. For every visualization you want to create, you start on a Power View sheet by creating a table, which you then easily convert to other visualizations, to find one best illustrates your data.
- To create a table, click a table or field in the field list or drag a field from the field list to the view. Power View draws the table in the view, displaying your actual data and automatically adding column headings.
- To convert a table to other visualizations, click a visualization type on the Design tab. Depending on the data in your table, Power View enables and disables different visualization types to give you the best visualization for that data.
Tip To create another visualization, start another table by clicking the blank view before selecting fields from the fields section of the field list.
Here’s a link to an informative article on Best Practices in Data Visualization.
In this article
Examples of visualizations available in Power View
- Slicer filtering the report to breads
- Tile flow navigation for tiles, currently on croissant
- Card in a tile container, filtered to the current tile (croissant)
- Line chart in tile container showing quantities consumed and server, filtered to croissants January to December
- Multiples, filtered to breads and sorted in descending order by quantity served
- Column chart filtered to breads, showing quantities served and consumed
Create a table
All visualizations start with a table. There are many different ways to create a table in Power View. Read more about tables in Tables in Power View.
Top of Page
Power View offers a number of chart options: pie, column, bar, line, scatter, and bubble. Charts can have multiple numeric fields and multiple series. You have several design options in a chart—showing and hiding labels, legends, and titles.
Charts are interactive: As you click values in one chart, you:
- Highlight that value in that chart.
- Filter to that value in all the tables, matrices, and tiles in the report.
- Highlight that value in all the other charts in the report.
For more information, see Filtering, Highlighting, and Slicers in Power View.
Charts are interactive in a presentation setting, too—for example, in reading and full-screen modes in Power View in SharePoint or in a Power View sheet in an Excel workbook saved to Excel Services or viewed in Office 365.
Pie charts are simple or sophisticated in Power View. You can make a pie chart that drills down when you double-click a slice, or a pie chart that shows sub-slices within the larger color slices. You can cross-filter a pie chart with another chart. Say you click a bar in a bar chart. The part of the pie chart that applies to that bar is highlighted, and the rest of the pie is grayed. Read about pie charts in Power View.
Scatter and bubble charts
Scatter and bubble charts are a great way to display a lot of related data in one chart. In scatter charts, the x-axis displays one numeric field and the y-axis displays another, making it easy to see the relationship between the two values for all the items in the chart.
In a bubble chart, a third numeric field controls the size of the data points. You can add a “play” axis to a scatter or bubble chart, too, to view data as it changes over time.
More about Bubble and scatter charts in Power View.
Line, Bar, and Column charts
Line, bar and column charts are useful for comparing data points in one or more data series. In line, bar, and column charts, the x-axis displays one field and the y-axis displays another, making it easy to see the relationship between the two values for all the items in the chart.
In a bar chart, categories are organized along the vertical axis and values along the horizontal axis. Consider using a bar chart when:
you have one or more data series that you want to plot;
your data contains positive, negative, and zero (0) values;
you want to compare the data for numerous categories; or
the axis labels are long.
In Power View, you have three bar chart subtypes to choose from: stacked, 100% stacked, and clustered.
More about Present your data in a bar chart
Data that is arranged in columns or rows on a worksheet can be plotted in a column chart. Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items. In column charts, categories are typically organized along the horizontal axis and values along the vertical axis.
In Power View, you have three column chart subtypes to choose from: stacked, 100% stacked, and clustered.
More about Present your data in a column chart
Line charts are similar to scatter charts. The difference is that a line chart only has one value axis (the vertical axis) and the horizontal axis only shows evenly spaced groupings (categories) of data. A line chart distributes category data evenly along a horizontal (category) axis, and distributes all numerical value data along a vertical (value) axis.
Consider using a line chart instead of a scatter chart if you want to:
Use text labels along the horizontal axis. These text labels can represent evenly spaced values such as months, quarters, or fiscal years.
Use a small number of numerical labels along the horizontal axis. If you use a few, evenly spaced numerical labels that represent a time interval, such as years, you can use a line chart.
Use a time scale along the horizontal axis. If you want to display dates in chronological order at specific intervals or base units, such as the number of days, months, or years, even if the dates on the worksheet are not in order or in the same base units, use a line chart.
More about Present your data in a scatter chart or a line chart
Top of Page
Maps in Power View use Bing map tiles, so you can zoom and pan as you would with any other Bing map. Adding locations and fields places dots on the map. The bigger the value, the bigger the dot. When you add a multi-value series, you get pie charts on the map, with the size of the pie chart showing the size of the total. Read more about maps in Power View.
Top of Page
Multiples: A set of charts with the same axes
With multiples, you can create a series of charts with identical X and Y axes and arrange them side by side – which makes it easy to compare many different values at the same time. Multiples are sometimes called “trellis charts.”
Read more about Power View Multiples Visualizations
Top of Page
A matrix is similar to a table in that it is made up of rows and columns. But a matrix has the following capabilities that a table does not:
display data without repeating values.
display totals and subtotals by row and column
with a hierarchy, you can drill up/drill down
collapse and expand the display
Read more about Working with a matrix in Power View
Top of Page
You can convert a table to a series of cards that display the data from each row in the table laid out in a card format, like an index card.
Read more about cards in Power View.
Top of Page
You can convert a table or matrix to tiles to present tabular data interactively. Tiles are containers with a dynamic navigation strip. Tiles act as filters – they filter the content inside the tile to the value selected in the tab strip. You can add more than one visualization to the tile, and all are filtered by the same value. You can use text or images as the tabs. Read more about Tiles in Power View.
This image shows number of medals won by countries competing in speed skating.
Top of Page