Open In App

Map Visualization in Excel Power View

Improve
Improve
Like Article
Like
Save
Share
Report

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.

creating-table

 

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.

adding-data-model

 

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. 

adding-data-category

Fig 3 – Adding Data Category

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

power-view-notification

 

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.

global-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.

selecting-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).

map-visualization

Fig 6 – Map Visualization

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.

message-box-displayed

 

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.

zoom-and-pan

 

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.

adding-fields-for-pie-chart

 

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.

pie-chart-visualization

Fig 10 – Pie Chart Visualization

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

pie-slice

 

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.

filter-option-in-map

 

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). 

filter-popup

 

Step 7: Output.

output

 



Last Updated : 25 Jan, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads