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.
What are Maps in Power BI?
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 visual 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 BI, 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.
To create Power BI Maps you need data to work with, so you can download the excel workbook template from the below link which is used for this example.
How to Create a Maps in Power BI?
In order to create power BI 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.
Download the workbook to use it to create power BI Map visual and follow below steps to create your first visual on Maps.
Step 1: Open Power BI software.
Step 2: Click on “Get Data” and choose the data form as “Excel”.
Step 3: Now file chooser window opens up, from this window choose the downloaded file from the saved location.
Step 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.
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 “Data” layout we can see the uploaded data.
Step 5: Come back to the “Report” layout and click on “Map” visual in power bi.
Before you go to the next step let me explain you the 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.
Step 6: By selecting the inserted blank Map visual drag and drop “City” column to “Location” field.
Now you must have already seen the map automatically finds these city names.
Step 7: Now drag and drop “Sales” column to the “Size” field.
Now we have bubbles on respective areas of the map.
Step 8: Once the data sets are plotted on the map, we need to play around with the formatting and other settings of the map.
First thing you need to do is to enlarge the map to fit the page view.
Step 9: By selecting the map visual in power bi click on the “Format” option to see various formatting options.
Step 10: Change each bubble color manually under “Data Colors” formatting.
Step 11: If you want to see the city name on each label then you can turn on Category label.
Step 12: You can increase or decrease the bubble size under “Bubbles”.
Step 13: We can change the theme of the map under “Map styles”.
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.
Things to Remember
- Map visual in power bi is required 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 an excel template. You may learn more about Power BI from the following articles –