Working with map data in Power View in Excel 2013 Preview


One of the new options that you have in Excel 2013 and Power View is to show data on maps. This is a feature that is awaited for, most data in the BI world contains some sort of geographical information.


This could be sales territories, customer locations or production plants, etc.

When I first tested this I thought that you would need to have geographical objects stored in your user database much like the technique I used in one of my previous posts. However this is much simpler, the only thing that you need is a geographical name like a region name, a postal code or even a street name.


This data gets sent to Bing and Power View uses the field that you put in the locations box to geo code the data.

power view map control

This can in certain cases be hard to do you really need to ensure that your field is uniquely identified. There are places that have the same name across the globe. You also need to ensure that if you use street names that Bing can successfully find then e.g. they have the correct postal code.

Bing maps is quite good on finding out locations of different addresses.

I tried with a very small sample that you can see below:



The first row is a full address, as suspected Bing had no trouble finding that address. In the second case I have not specified the zip code or the country but Bing had no problem finding that at all. The third one also misses the zip code and the country and again Bing had no trouble. If I removed Stockholm from the third case and just added the country then Bing was unable to find the address.

If Bing cannot find the location of the address then nothing is shown on the map.

You can also get nice zoom able maps in Power View. Power View have the capability of understanding hierarchies in the new version. This is something that power users have asked for and now it is here. I was happy to see that it worked in maps as well.

I created the following small sample table



Then in PowerPivot I created a hierarchy that goes from country down to region and then down to plats.


If I add this to a Power View report the map report will look like this:


As you can see I only have one marker on top of Sweden showing me the country level. If I double click on the marker then I will zoom in to the next level showing me the regions that I have in my hierarchy.



There are a lot of other visualizations and things that you can do with the mapping components in Power View. You have a lot of possibilities with vertical and horizontal multiples as well as color. There are however some things that does not work. You can not use KPI statuses on maps and you can not show regions the way that you can do in Reporting Services. However this is much simpler and easier to work with and more people will be able to use it.

Comments (8)

  1. Chris says:

    Is there an option to display the number the bubble represents without having to hover the mouse over it?

  2. Hi Chris,

    If you check on the layout tab you can see what options you have on the map, you can add a label to the map. The label is the value that you put in the location box.  So what you can do is if you have a latitude and longitude for the places that you would like to show instead of an address or place then you can add the value as the location.

    Hope this helps, Simon

  3. Michael Limmer says:

    Hi Simon,

    I am sorting my geogrphical points using the postcode but I wanted the actual address to show in the data bubble… can this be done..?

  4. Hi Michael you can only show what is in the Locations box unfortunately.


  5. Ramesh says:

    Can we change the dot to some other type of marker like a peg or a Pin.

  6. Ramesh sorry for missing your comment, this is not possible in the current version.

  7. Jon says:

    Hi Simon

    Exactly what data gets shared with Bing – just the location data or any other information associated with it, eg sales figures?

  8. jon says:

    Hi Simon

    Exactly what data is shared with Bing, the address only or any other associated information, eg sales figures by location?


Skip to main content