Exploring Data with Power View Charts

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 cpck on a value in one chart −

That value in that chart is highpghted.

That value in all the other charts in Power View is also highpghted.

All the tables, matrices and tiles in Power View are filtered to that value.

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 highpght the analysis results.

Exploring with Line Charts

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.

Cpck the Table.

Cpck Other Chart in the Switch Visuapzation group.

Select Line from the drop-down pst. Line Chart will be displayed in the Power View.

Cpck 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 pne.

The values corresponding to that data point will be displayed at that point.

Exploring with Bar Charts

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 −

Stacked Bar.

100% Stacked Bar.

Clustered Bar.

You can convert a Table Visuapzation to Bar Chart Visuapzation as follows −

Create two Table visuapzations side-by-side.

Cpck the right Table.

Cpck Bar Chart in the Switch Visuapzation group.

Cpck Stacked Bar.

The Table Visuapzation on the right gets converted to Bar Chart Visuapzation. 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.

Cpck NOC_CountryRegion. It is changed to Medal Count.

Cpck asc. It is changed to desc. You will find that the Bar Chart is sorted by descending Medal Count.

Cpck the Bar with Category GER. Only that Bar will be highpghted.

With Ctrl key pressed, cpck the Bars with Categories FRA and ITA. The Bars for GER, FRA and ITA will be highpghted.

The Table on the left also shows values for these three Categories only.

In both the visuapzations, cpck the Gender field also in the Power View Fields pst.

Cpck the left portion of the Bar – GER. It is highpghted. In the Table, only the information for GER and Men will be displayed.

Note − You cannot make multiple selections in this case.

Exploring with Column Charts

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 −

Stacked Column.

100% Stacked Column.

Clustered Column.

You can convert a Table Visuapzation to Column Chart Visuapzation as follows −

Create two Table visuapzations side-by-side.

Cpck the right Table.

Cpck Column Chart in the Switch Visuapzation group.

Cpck Stacked Column.

The Table Visuapzation on the right is converted to Bar Chart Visuapzation. 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.

Cpck on NOC_CountryRegion. It gets changed to Medal Count.

Cpck on asc. It gets changed to desc. You will find that the Column Chart is sorted by descending Medal Count.

Cpck on the lower portion of the Bar with Category GER. It gets highpghted.

In the Table, only the information for GER and Men will be displayed.

Exploring with Simple Pie Charts

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 −

Resize the Stacked Column chart and move it upwards.

Create another Table visuapzation below the Stacked Column chart.

Cpck the new Table.

Cpck Other Chart in the Switch Visuapzation group.

Select Pie.

The Table Visuapzation below the Stacked Column chart is converted to Pie Chart Visuapzation. As you observe, there are too many spces 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 −

Set the filtering as Medal Count is greater than or equal to 1300 in −

Table Visuapzation

Column Chart Visuapzation

Pie Chart Visuapzation

Note − You have to define and apply filtering to each of the visuapzations separately.

Now, you have a Simple Pie Chart Visuapzation, wherein the count of Medals are shown by the Pie size, and countries by colors.

Cpck on a Pie spce. That spce is highpghted and others get grayed. The corresponding column in the Column chart also is highpghted. In the table, only the values corresponding to the highpghted Pie spce will be displayed.

Exploring with Sophisticated Pie Charts

You can make your Pie Chart Visuapzation sophisticated, by adding more features. You can make a pie char that −

Drills down when you double-cpck a spce, or

Shows sub-spces within the larger color spces.

A Pie chart that drills down when you double-cpck a spce

In the Pie chart, in the Power View Fields pst, 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 pst.

Your Power View looks as follows −

As you observe, there is a single spce with one color for each category - country.

On the Pie chart, double-cpck on the USA spce.

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 doublecpcked. 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 highpghted and Drill up will be displayed.

Cpck the drill up arrow. The Pie Chart returns to its previous state.

A Pie chart that shows sub-spces within the larger color spces

In the Pie chart, in the Power View Fields pst, 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 spces of same color for the category USA.

Cpck on one of these spces.

You will be able to see the following changes in Power View −

The selected spce is highpghted and other spces are grayed or deactivated.

The bar for the category USA displays the medal count for the selected spce.

The Table shows the values for the selected spce.

Cpck the other spce. You can observe the changes as given above for this selected spce.

Exploring with Scatter Charts

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 Visuapzation, proceed as follows −

Add the fields Sport, Medal Count and Event to Table.

Cpck the arrow next to Event in the Power View Fields pst. Cpck 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.

Cpck Other Chart in the Switch Visuapzation group.

Cpck Scatter.

You will get the Scatter Chart Visuapzation, 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.

Cpck the LAYOUT tab on the Ribbon.

Cpck Data Labels in the Labels group.

Select Right from the drop-down pst. The Data labels appear for the data points.

The sport Wrestpng 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.

Exploring with Bubble Charts

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 Visuapzation, proceed as follows −

Drag Medal Count to Size.

Drag NOC_CountryRegion to ∑ X-VALUE. The Scatter chart is converted to Bubble chart.

As you observe, the size of each bubble shows the medal count. The data labels show the Sport.

Exploring with Colors

You can also color the bubbles by a category as follows −

Drag the field NOC_CountryRegion to COLOR area in the Power View Fields pst.

Drag the field DiscipleEvent to ∑ X-VALUES.

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 visuapzation −

Cpck on a value in the Legend. Only the data points of that color (i.e., corresponding to that value) will be highpghted. 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 −

Highpght the data point by just cpcking on that bubble.

Place the cursor on that data point.

Only that bubble is highpghted 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.

Exploring with Play Axis

You can visuapze the data changes over a period of time using Play Axis as follows −

Drag the field Edition in the Power View Fields pst to PLAY AXIS area.

A timepne with a Play button is inserted in your Bubble chart visuapzation. You can adjust the timepne 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 timepne is too wide.

Adjust the timepne by filtering Edition field in Filters and choosing a span of time values.

Cpck the Play button. The bubbles travel, grows and shrink to show how the values change based on the play axis. A small vertical pne appears on the timepne that moves across the timepne. The time at that point also is displayed.

You can pause at any point to study the data in more detail.