Map Visualization in Excel Power View

We can use maps to present our data in a geographical context. Power View Maps employ Bing Map Tiles, so one can zoom and pan it like other Bing maps. Power View must submit the data to Bing through a secure online connection for geocoding in order for the maps to function and work. As a result, it asks you to activate the content, which involves adding location and values to the map and placing the dots on it. The greater the value, the larger the dot. When you add a multi-value series, pie charts appear on the map, with the size of the pie chart representing the total data. In this article, we will learn about Map Visualization in Power View.

Steps to Create a Power View Map

Step 1: Create Table.

In order to create a power view map. First, we will create a table. For this, we will be using Country and Events as two different columns of our table. In Power View, we can see two fields Country and Events.

Step 2: Making Country Field Global.

In Power View Map Visualization, we need to make our Country field global, In order to make it, we will need Power Pivot. For this go to Ribbon Tab > Power Pivot > Add to Data Model > Manage.

Once we click on the Manage option, excel will open the Power Pivot Window, we need to Select Country Column > Advanced > Data Category: Uncategorized. We need to select Classification.Country.LabelName from the drop-down menu list. 

After this, excel will pop up a notification window for changing the Data Model. We need to click on the OK button.

Once we are done updating the Data Model. We will move to our excel sheet. In the Power View Fields window, we can find a globe symbol added to our Country column in the Range table. It signifies that the geographic place is contained in the country field.

Step 3: Convert Table To Map Representation.

In this step, we will convert our table to a map representation. For this Select Table > Design > Switch Visualization > Map.

Once we click on the Map option, Excel will create the map visualization from the table visualization. Power View creates a map with dots for each geographic place (Here, it is a country). The size of the dots represents the numeric value(Here, it is the value of the Event field).

When we place the cursor over the dots. It will display a message box with the information for the Country name and the Event value which is represented by that dot.

Step 4: Zooming and Panning The Map.

Excel provides us built-in feature to zoom and pan the map. We can zoom in or zoom out the map along with panning in left, right, up, and down directions using the cursors provided in the top right corner of the map.

Step 5: Convert Dot To Pie Chart.

In this step, we will convert dots into a pie chart. In order to convert the dot to pie chart we need to drag the Country field from the Range table to LOCATIONS and Events to SIZE. To convert dots to the pie chart, we need a multi-axis, for this, we will use the Season field. We will drag Season to the COLOR section, which represents the season of the country such as summer or winter.

Once we do this, excel will convert the dots into a pie chart. Excel adds a Season Label depicting the season and their associated colors.

We can click on Pie Slice to enlarge the pie chart. It will highlight that particular chart and other will be deactivated.

Step 6: Filtering Pie Chart.

In this step, we will filter our pie chart. For this, we will use the filter option, in the top right corner of the map a filter button is shown. it shows the filter icon. After clicking on it, it shows the Map in the filters area.

Once we click on it, excel will open a filter popup window, we will use specifying the filter criteria depending on our requirement to filter out the map data(Here, we are filtering only for the winter season). 

Step 7: Output.