Tip:
Highlight text to annotate it
X
Pie charts are simple or sophisticated in Power View.
I’ll start with a basic pie chart that looks at how many times a particular sport has been played at the Olympic games.
From the Medals table, select Year. Change Year to Distinct Count. Otherwise Power View will add the years together.
From the Events table, select Sport.
To convert the table into a pie chart , select Pie from the Switch Visualization gallery.
This pie chart is too busy, I’ll look at winter sports only. To do this I drag Season into the Filters pane and select Winter.
Hover over each color to see the details. Skiing has been part of the Olympics 20 times, Skating 22 times, and Curling 3.
Clicking on a Sport in the legend, highlights that piece of the pie. And I can select directly on the pie chart with a single click.
To clear the highlighting, click the blank area of the visualization.
Now I'll create a pie chart that drills down when I double-click a color.
I use a hierarchy that already exists in the data model, it is named SDE and stands for Sport-Discipline-Event. In my data model,
one or more Events make up a Discipline and one or more Disciplines make up a Sport. Click SDE to add it to the Color field.
At first glance, my pie chart looks unchanged. But double-click any of the Sports to drill down.
Double-clicking Skiing drills down to the Disciplines level. I now see all the Disciplines that make up the Sport of Skiing.
Double-click again, and I drill down to the Events level. Here I see all the Events that make up the Alpine Skiing Discipline.
To drill up, click the arrow at the top right corner of the visualization.
Let’s add more detail to my pie chart using Slices.
From the Medals table, grab Gender and drag it to the Slices field.
Gender now slices the colors on my chart. In Skiing, womens' teams have participated in 17 Olympic games and mens' teams in 20.
And in the Sport of skating, men and women have participated in the same number of Olympic games -- 22.
And I can still drill down by color. Double- clicking Skating drills down to the Disciplines that make up the Sport of Skating.
In the Discipline of Short Track Skating, women and men both have participated in 5 Olympic games.
Double-click Short Track S to drill down to the Events that make up the Short Track Discipline.
Only women participate in the 3000 Meter Relay and only men in the 5000 Meter Relay. In the 1000 Meter, men have competed in 5
Olympic games and women in 4. Click the up arrow to drill back up again.
Pie charts can also be cross-filtered by other visualizations. I’ll create a bar chart for population by country/region.
In the Switch Visualization gallery, I select Bar Chart > Clustered to convert the table into a chart.
For this report, I’m only interested in six country/regions. In the Filters pane, select Chart.
For Country Name, select Austria, Canada, Chile, Czech Republic, France, Germany.
For Country Name, select Austria, Canada, Chile, Czech Republic, France, Germany.
By clicking on one, or more, bars, I filter the pie chart by the selected country/region.
The part of the pie chart that applies to that bar is highlighted, and the rest of the pie is dimmed.
It looks like Chile hasn't won any winter sports medals.
France, on the other hand, has won medals in four different winter sports. As a percentage of total medals awarded in a Sport, France
has won a high percentage of medals in Skiing and in Men's Skating. I can tell this by the size of the highlight compared to the
dimmed area. Remember, the dimmed area represents ALL medals ever won in that Sport. When I drill down in Skating, I discover
that France has won quite a lot of medals in Figure skating but none in either Short Track or Speed Skating. Women figure skaters have
medaled in 7 different Olympics and men figure skaters have medaled in 10 Olympics. Drill down to the Events level for Figure
Skating to discover even more details.
Please visit office.com for more information.