Maps in Power BI

What are Maps in Power BI?

Maps are a representation of the location of any place which uses coordinates or also known as latitudes and longitudes to display a place on a map, in power bi it is integrated with bing maps, bing being a search engine just like google to help a user in the creation of maps.

The map is a kind of vision as 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.

The thing is Power BI maps are integrated with “Bing Maps” so that it coordinates with location names from the data. So, using Bing Map, we can create two kinds of Maps 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 Map, and another one is Filled Maps. What Bing does is recognizes the location name, address, or any geographical attribute and plot 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 Map, you need data to work with, so you can download the excel workbook template from the below link, which is used for this example.

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?

In order to create a map visual, you need to have a set of data which has location names in it. Below is the sales data I have prepared with city names in India.

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 on “Get Data” and choose the data form as “Excel.”

    Map in Power BI (Select Get Data)

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

    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 selected excel file.

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

  5. Come back 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 me explain to you the fields of 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 the 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’s not touch that at this point in time.

  6. By selecting the inserted blank Map visual, drag, and drop the “City” column to the “Location” field.

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

  7. Now drag and drop the “Sales” column to the “Size” field.

    Map in Power BI (Add Sales)
    Now we have bubbles on respective areas of the map.
    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, then you can turn on the Category label.

    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: Power BI dashboard file can also be downloaded from the link below, and the final output can be viewed.

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

Things to Remember

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

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

  • 6 Online Courses
  • 29+ Hours
  • Verifiable Certificate of Completion
  • Lifetime Access
LEARN MORE >>