Power BI Filled Maps will fill the Map with colors based on the geological data that you provide. In this article we will show you, How to Create a Filled Map in Power BI with example.
For this Filled 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 Filled Map in Power BI
Dragging any geographical data to Canvas region will automatically create a Map for you. First, let me drag the Country Names from the world Population table to the Canvas.
Click on the Filled Map under the Visualization section. This will automatically convert a Map into a Filled Map.
Next, Drag and Drop the 2016 Population from Fields section to Legend region.
From the above screenshot, you can see the filled map that represent in the country wise population in the year 2016
Create a Filled Map in Power BI – Approach 2
First, click on the filled Map under the Visualization section. This will automatically create a filled Map with dummy data as shown in below screenshot.
In order to add data to a filled Map, 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 bubbles color.
Let me drag the country name from Fields section to Location Section. You can do this by dragging the country name to Location section, or simply check mark the country name column.
Next, let me add the 2016 population to legend section. Now you see the filled map
Let me do some quick formatting to this filled Map
NOTE: I suggest you to refer Format Filled Maps article to understand the formatting options.
Hover-over any region to see the country name, and the country population.