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.
