What are Maps in Power BI?
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.
You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor 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.
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.
Download the workbook to use it to Map visual.
Like this, we can do several other settings and formatting in a bid to make the map visual look more beautiful.
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.
Before you go to the next step, let us explain the fields of the “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.
You must have seen that the map automatically finds these city names.
Now we have bubbles on respective areas of the map.
The first thing you need to do is to enlarge the map to fit the page view.
Note: We can also download the Power BI dashboard file from the link below. We can view the final output.
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.
Recommended Articles
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: –
- Heat Map in Power BIPower Query using Excel
