Maps in Power View display your data in the   context of geography.
In less than 15 seconds, I can create an   interactive map to look at medal count by   country/region.
I start with MedalCount and   NOC_CountryRegionCode.
From the Switch Visualization gallery, I select   Map. If you haven’t already Enabled Content,   Power View will prompt you to do so.
Instantly my data is converted to a map. The   bigger the bubble, the more medals won.  I   can hover over each bubble to get specific
quantitative details, here I see that Uzbekistan   has won 18 medals and Finland has won   710.
The maps are powered by Bing and Power   View sends the data to Bing through a   secured web connection for geocoding.
To make my map more interesting (and colorful), I drag the Medal category to the   COLOR field.
Now my bubbles become little pie charts.    Orange represents the number of bronze   medals, blue gold, and red silver.
The colors may be different in your report, and   at the current time, there is no way to assign   specific colors, like gold, silver, and bronze, to
the pie charts. However, I can change the   Legend order from alphabetical to Gold first,   Silver second, then Bronze.
I’ll do this in PowerPivot. In the Medal table, I   select the Medal column and from the Sort   and Filter gallery, select Sort by Column.
In the dialog that opens, the Medal column is   already selected as the Sort column and I   add MedalValue as the By column.
MedalValue assigns values to the medals: 1 to Gold, 2 to Silver, and 3 to Bronze.
When I click OK I see no change in   PowerPivot, but back in Power View, the data   model is updated, and my Legend is now
sorted the way I like it.
Because my map in Power View uses Bing   map tiles, I can zoom and pan as I would with   any other Bing map.
Zooming and panning is smooth and quick.  I   can even get down to the street level if I need   to.
Finland has done well at the Olympics – 217   silver, 179 gold, and 314 bronze medals.
Power View maps are interactive – I can   cross-filter charts and other Power View   visualizations, and vice versa.
I’ll start by slicing my map by Season.  When I   add a slicer, clicking one or more slicer   values immediately updates my map.
Looking at Finland again, notice how Power   View responds instantaneously to data   changes.  With this slicer it's easy to see that
Finland takes a larger share of medals at the   winter games.
In addition to BEING filtered, maps can do the   cross filtering. I’ll add a chart that displays the   number of events by sport.
Now I’ll use my map to filter the table by country/region and also by season. The possibilities are infinite.
If I convert this table to a bar chart, I can   cross-filter the map by clicking the bars.
As I click data points, it takes Power View less than a second to update the map to show the applicable data.
Even when applying BOTH filters and slicers to the map.
I’ll show you just one more cool thing I can do   with maps. I can tile my maps.  Let’s say I   want to look at medal count by year.  Drag
Year to the Tile By field and my map now   shows me medals by year.
Please visit office.com for more information.
