Power BI Maps will help you to visualize the geological data. In this article we will show you, How to Create a Map in Power BI with example.
For this Power BI Map demonstration we are going to use the World Population data that we downloaded from the Data bank (in Excel format). Please refer Connect to Excel article to understand the steps involved in working with Excel.
How to Create a Map in Power BI
Drag and Drop any geographical data to Canvas region will automatically create a Map for you. Let me drag the Country Names from the world Population table to the Canvas.
From the below screenshot, you can see that the power bi has created a map for you.
Next, Drag and Drop the 2016 Population from Fields section to Legend region.
Hover-over any bubble to see the country it represent, and the country population.
Create a Map in Power BI Approach 2
First, click on the Map under the Visualization section. This will automatically create a Map with dummy data as shown in below screenshot.
In order to add data to a Map in Power BI, we have to add required fields:
- Location: Please specify the Geological Column that represent the Bubbles.
- Legend: Specify the Column that will sub-divide the Location data. Something like Territory, Country, Region, or Continent
- Latitude and Longitude: If your data has latitude and longitude information then you can them to get the exact location.
- Size: Specify the Column that represent the Bubbles size.
- Color Saturation: Any Numeric value that will decide the Power BI map bubbles color.
Let me drag the State from Fields section to Location Section. You can do this by dragging State to Location section, or simply check mark the State column.
Next, let me add the Sales Amount to Size section. Now you see the size difference in the bubbles
Next, let me add Country Name to the Tool tip section. Now, if you hover-over any bubble will show you the information about the Country, State, and its Sales Amount
Let me add Country Name to the Legend section. As you can see, color of bubbles are changed based on the country they represent.
To demonstrate the Color Saturation section of a Power BI map, we added the Order Quantity to the Color Saturation section. As you can see from the below screenshot, color of each circle has changed as per the Order Quantity. Remember, you can’t use the Legend and Color Saturation at the same time.
Let me do some quick formatting to this Power BI Map
NOTE: I suggest you to refer Format Maps article to understand the formatting options.