In Power View, you have a number of Chart options: Pie, Column, Bar, Line, Scatter, and Bubble. The Charts in Power View are interactive. If you click on a value in one chart −
Thus, Power View Charts serve as interactive, pictorial data analysis tools. Further, the charts are interactive in a presentation setting also, which would enable you to highlight the analysis results.
You can use Line charts for comparing data points in one or more data series. Line charts distribute category data evenly along a horizontal (category) axis, and all numerical value data along a vertical (value) axis.
Suppose you want to display the Medal Count for each country.
Create a Power View with the fields NOC_CountryRegion and Medal Count selected. By default, Table will be displayed.
Click the Table.
Click Other Chart in the Switch Visualization group.
Select Line from the drop-down list. Line Chart will be displayed in the Power View.
Click on the Line or the Category (x-axis) axis.
Drag to left or right. The Categories to the left or right will be displayed and Line chart will be displayed accordingly.
Place the cursor on any of the data points on the line.
The values corresponding to that data point will be displayed at that point.
You can use Bar charts for comparing data points in one or more data series. In a Bar chart, categories are organized along the vertical axis and values along the horizontal axis. In Power View, there are three Bar chart subtypes −
You can convert a Table Visualization to Bar Chart Visualization as follows −
The Table Visualization on the right gets converted to Bar Chart Visualization. As you observe, the y-axis values are sorted by the category values in ascending order.
Take the cursor above the Bar chart. You will find – sort by NOC_CountryRegion asc.
Click NOC_CountryRegion. It is changed to Medal Count.
Click asc. It is changed to desc. You will find that the Bar Chart is sorted by descending Medal Count.
Click the Bar with Category GER. Only that Bar will be highlighted.
With Ctrl key pressed, click the Bars with Categories FRA and ITA. The Bars for GER, FRA and ITA will be highlighted.
The Table on the left also shows values for these three Categories only.
In both the visualizations, click the Gender field also in the Power View Fields list.
Click the left portion of the Bar – GER. It is highlighted. In the Table, only the information for GER and Men will be displayed.
Note − You cannot make multiple selections in this case.
You can use Column charts for showing data changes over a period of time or for illustrating comparison among items. In Column charts, categories are along the horizontal axis and values along the vertical axis.
In Power View, there are three Column chart subtypes −
You can convert a Table Visualization to Column Chart Visualization as follows −
The Table Visualization on the right is converted to Bar Chart Visualization. As you observe, the x-axis values are sorted by the category values in ascending order.
Take the cursor to above the Column chart. You will find – sort by NOC_CountryRegion asc.
Click on NOC_CountryRegion. It gets changed to Medal Count.
Click on asc. It gets changed to desc. You will find that the Column Chart is sorted by descending Medal Count.
Click on the lower portion of the Bar with Category GER. It gets highlighted.
In the Table, only the information for GER and Men will be displayed.
Pie charts in Power View are simple or sophisticated. You will learn simple Pie charts in this section. You will learn sophisticated Pie charts in the next section.
Start with creating a Pie chart as follows −
The Table Visualization below the Stacked Column chart is converted to Pie Chart Visualization. As you observe, there are too many slices in the Pie chart as there are many categories (countries). Note that Pie charts work well only when the number of categories is 8 or less.
You can reduce the number of categories by filtering the values as follows −
Note − You have to define and apply filtering to each of the visualizations separately.
Now, you have a Simple Pie Chart Visualization, wherein the count of Medals are shown by the Pie size, and countries by colors.
Click on a Pie slice. That slice is highlighted and others get grayed. The corresponding column in the Column chart also is highlighted. In the table, only the values corresponding to the highlighted Pie slice will be displayed.
You can make your Pie Chart Visualization sophisticated, by adding more features. You can make a pie char that −
In the Pie chart, in the Power View Fields list, drag the field Gender to COLOR area, to below the field NOC_CountryRegion. This means you have two categories.
In the Table, include Gender also in the Fields list.
Your Power View looks as follows −
As you observe, there is a single slice with one color for each category - country.
On the Pie chart, double-click on the USA slice.
The Pie chart in your Power View will be changed to show values by Gender, which is the second category, for the selected category (USA). The colors of the pie chart now show the percentages of the second field, i.e., Gender, filtered for the pie color you doubleclicked. In other words, the Pie chart was drilled down. As you observe, a small arrow appears on the top right corner of the Pie chart. If you place the mouse over it, the arrow is highlighted and Drill up will be displayed.
Click the drill up arrow. The Pie Chart returns to its previous state.
In the Pie chart, in the Power View Fields list, drag the field Gender from COLOR area to SLICES area.
Your Power View looks as follows −
As you can see, in the Pie chart, there are two slices of same color for the category USA.
Click on one of these slices.
You will be able to see the following changes in Power View −
You can use Scatter charts to display many 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.
To create a Scatter Chart Visualization, proceed as follows −
Add the fields Sport, Medal Count and Event to Table.
Click the arrow next to Event in the Power View Fields list. Click Count (Distinct). The field Event changes to the numeric field Count of Event. Therefore, you have one category field – Sport and two numeric fields – Medal Count and Count of Event.
Click Other Chart in the Switch Visualization group.
You will get the Scatter Chart Visualization, with the data points displayed as circles of same size, showing how the Count of Event and Medal Count values are related for each sport.
The sport Wrestling has less number of medals in more number of events as compared to the sport Aquatics that has more number of medals in less number of events.
You can use Bubble charts to display many related data in one chart. In Bubble 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. A third numeric field controls the size of the data points.
To create a Bubble Chart Visualization, proceed as follows −
As you observe, the size of each bubble shows the medal count. The data labels show the Sport.
You can also color the bubbles by a category as follows −
As you observe, Legend shows the values of the category that is in COLOR area and the respective colors. The data labels correspond to the category in DETAILS area. The size of the data points is by the area ∑ SIZE.
Next, you can see how selecting a category in Legend changes the visualization −
Click on a value in the Legend. Only the data points of that color (i.e., corresponding to that value) will be highlighted. All the other data points will be deactivated.
As you observe, all the sports corresponding to the selected country are displayed and the size of each bubble represents the medal count.
If you want to know the details of a single data point −
Only that bubble is highlighted and the rest of the bubbles get grayed. All the information about that data point will be displayed in a box next to the data point.
You can visualize the data changes over a period of time using Play Axis as follows −
A timeline with a Play button is inserted in your Bubble chart visualization. You can adjust the timeline by filtering the Edition field values in the Filters. This would be useful if you want to focus on a particular time range or if the timeline is too wide.
Click the Play button. The bubbles travel, grows and shrink to show how the values change based on the play axis. A small vertical line appears on the timeline that moves across the timeline. The time at that point also is displayed.
You can pause at any point to study the data in more detail.