Maps in Power BI

Updated on January 2, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What are Maps in Power BI?

Maps represent the location of any place, which uses coordinates or latitudes and longitudes to display a place on a map. In Power BI, it is integrated with bing maps. Bing is a search engine like Google to help users create maps.

The map is a kind of vision part of Power BI visualization software. Using this visual, we can show geographic-based or location data values on respective areas of the map according to the location name. You must be wondering how this map visually identifies the location on the map.

Power BI maps are integrated with “Bing Maps” to coordinate with location names from the data. So, we can create two kinds of map visuals in Power BIVisuals In Power BIIn Power Bi, there are some built-in visuals for data visualization, as well as some custom visuals. Custom visuals are user-defined and allow users to use their own creativity in terms of how they want to present data. For example, one can use lines and dots in a flashing and floating manner to display changes in data over time.read more. One is a “Bubble Maps,” and another is a “Filled Maps.” Bing recognizes the location name, address, or any geographical attribute and plots the selected data on the map.

Power-BI-Maps

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Maps in Power BI (wallstreetmojo.com)

To create a map, you need data to work with. So, you can download the Excel workbook template from the link below, which is used for this example.

–>> If you want to learn Power BI professionally, then Power BI Basics Course (5+ hours) is the perfect solution. This course will introduce you to a wide range of Power BI concepts like collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights, Creating Reports in Power BI Desktop, Analyze Data with Excel, Graphs & Visualizations, Interactive Dashboards along with some real life examples.

You can download this Maps in Power BI Excel Template here – Maps in Power BI Excel Template

How to Create a Maps in Power BI?

To create a visual map, you must have a data set with location names. For example, we have prepared the sales data with city names in India below.

Map in Power BI (Sales Data)

Download the workbook to use it to Map visual.

Follow the below steps to create your first visual on maps.

  1. Open Power BI software.

  2. Click “Get Data” and choose the data form as “Excel.”


    Map in Power BI (Select Get Data)

  3. Now, the file chooser window opens up. Choose the downloaded file from the saved location from this window.


    Map in Power BI (Open the File)

  4. Before you upload the data, choose the “City_Sales.” Then, it will ask you to select the Data Table from the Excel file.


    Map in Power BI (Preview Data)
    The table name in the workbook is “City_Sales, so we have chosen the file. We will click “Load” to upload the data to Power BI software. Under the “Data” layout, we can see the uploaded data.
    Map in Power BI (upload data)

  5. Return to the “Report” layout and click on the “Map” visual.


    Map in Power BI (click on Map)
    Before you go to the next step, let us explain the fields of the “Map” visual.
    Map in Power BI (fields of Map visual)
    Location is nothing but geographical names. In our example, city names are the location.
    Latitude is the code available to find the location map on Bing.

    Longitude is the code available to find the location map on Bing.

    Size is nothing but what data values we need to show as a bubble on the map. In this example, data “Sales Value” is what we need to show the bubble.

    Note:
     Latitude and Longitude are broader concepts. Let us not touch that at this point.

  6. Selecting the inserted blank map visual, drag and drop the “City” column to the “Location” field.


    Map in Power BI (Add City)
    You must have seen that the map automatically finds these city names.
    Map in Power BI (City Names)

  7. Drop the “Sales” column to the “Size” field.


    Map in Power BI (Add Sales)
    Now we have bubbles on respective areas of the map.Map in Power BI (show bubbles)

  8. Once the data sets are plotted on the map, we need to play around with the formatting and other settings of the map.

    The first thing you need to do is to enlarge the map to fit the page view.

    Map in Power BI (fit page view)

  9. By selecting the map visual, click on the “Format” option to see various formatting options.


    Map in Power BI (All Format)

  10. Change each bubble color manually under “Data Colors” formatting.


    Map in Power BI (Add Data Colors)

  11. If you want to see the city name on each label, you can turn on the “Category labels.”


    Map in Power BI (Add Category label)

  12. You can increase or decrease the bubble size under “Bubbles.”


    Map in Power BI (Add bubble size)

  13. We can change the theme of the map under “Map styles.”


    Map in Power BI (choose Grayscale)

Like this, we can do several other settings and formatting in a bid to make the map visual look more beautiful.

Note: We can also download the Power BI dashboard file from the link below. We can view the final output.


You can download this Power BI Maps Template here – Power BI Maps Template

Things to Remember

  • The map visual requires the exact location name to identify the location on the map.
  • The size should always be the numerical data set to show the bubble size.
  • We can increase, decrease the bubble size and change each bubble’s colors to a different color.

This article is a guide to Power BI Maps. Here, we learn the steps you need to build your visual map in Power BI, along with an example and downloadable template. You may learn more about Power BI from the following articles: –