Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop

Maps in Power View display your data in the context of geography. Maps in Power View use Bing map tiles, so you can zoom and pan as you would with any other Bing map. To make maps work, Power View has to send the data to Bing through a secured web connection for geocoding, so it asks you to enable content. Adding locations and fields places dots on the map. The larger the value, the bigger the dot. When you add a multi-value series, you get pie charts on the map, with the size of the pie chart showing the size of the total.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Create a map

  1. Drag a geographic field such as Country/Region, State/Province, or City to the Power View sheet or view to create a table.

    Tip: A geographic field might be marked with a small globe icon. This identifies it as a geographic field.

  2. Drag a numeric field such as Sales to the table.

  3. On the Design tab, click Map.

  4. Click Enable Content to send the data to Bing for geocoding through a secured web connection.

Power View creates a map with a dot for each value, such as each city. The size of the dot represents the value.

  1. To convert the dots to pie charts, add a category field to the Color box for the map.

    Power View map of the U.S. with pie charts

Maps cross-filter charts and other Power View visualizations, and vice versa. For example, when you click a data point on a map, the other charts are filtered by that data point. Likewise when you a click bar in a bar chart, the map is filtered to the data that relates to that bar.

Notes: 

  • You can’t zoom in as close in maps in Power View as you can in the same maps in Bing.

  • The Bing mapping service integrated with Power View isn’t currently available in some locales. In unsupported locales, Power View plots map data points on a generic map.

Make map data unambiguousPower View

Power View map of Europe with bubbles showing sales amount

Map data can be ambiguous. For example, there’s a Paris, France, but there’s also a Paris, Texas. Your geographic data is probably stored in separate columns – a column for city names, a column for state or province names, etc. – so Bing may not be able to tell which Paris is which. You fix this by making the geographic values unique.

The place to fix this is in the data model, and not in Power View. If the data model is in an Excel file (XLSX), then in Power Pivot, you create a calculated column that concatenates the values in the two columns to create one unique value.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.
  1. In Excel, click the Power Pivot tab and then click Manage Data Model.

Don’t see a Power Pivot tab? Start Power Pivot in Microsoft Excel 2013.

  1. Click the tab for the table containing geographic data.

  2. Click Add Column in the column to the right of the table and type a formula similar to this in the formula bar above the worksheet:

    =[StateProvinceName] & ", " & [RegionCountryName]

  3. Press Enter.

Power Pivot fills in the column with the values in each row formatted with a separating comma:

StateProvinceName, RegionCountryName

  1. Right-click the column to rename it.

  2. Go back to your Power View sheet in Excel. Refresh the data and use your new column in your maps.

This doesn’t change the underlying data. The new calculated column is in the data model, not in the source data.

Tip: This formula uses Data Analysis Expression (DAX) language. Learn more about DAX in this QuickStart: Learn DAX Basics in 30 Minutes.

Notes: Video copyrights:

  • Olympics Dataset © Guardian News & Media Ltd.

  • Flag images courtesy of CIA Factbook (cia.gov)

  • Population data courtesy of UNData (data.un.org ) on Microsoft Azure Marketplace. 

  • Olympic Sport Pictograms by Thadius856 and Parutakupiu, distributed according to the license on Wikimedia Commons (creativecommons.org/licenses/by-sa/3.0/)

Top of Page

See Also

Charts and other visualizations in Power View

Power View: Explore, visualize, and present your data

Power View and Power Pivot videos

Tutorial: Import Data into Excel, and Create a Data Model

Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×