A filled map uses shading or tinting or patterns to display how a value differs in proportion across a geography or region. Quickly display these relative differences with shading that ranges from light (less-frequent/lower) to dark (more-frequent/more).
Note: When working with countries or regions, use the three-letter abbreviation to ensure that geocoding works properly in map visualizations. Do not use two-letter abbreviations, as some countries or regions may not be properly recognized.
If you only have two-letter abbreviations, check out this external blog post for steps on how to associate your two-letter country/region abbreviations with three-letter country/region abbreviations.
Filled maps are a great choice:
to display quantitative information on a map.
to show spatial patterns and relationships.
when your data is standardized.
when working with socioeconomic data.
when defined regions are important.
to get an overview of the distribution across the geographic locations.
In this video, Kim creates a basic map and converts it to a filled map.
To create your own filled map, download the Sales and Marketing sample by signing in to Power BI and selecting Get Data > Samples > Sales and Marketing.
and select the Geo > State field.
Convert the chart to a filled map. Notice that State is now in the Location well. Bing Maps uses the field in the Location well to create the map. The location can be a variety of valid locations: countries, states, counties, cities, zip codes or other postal codes etc. Bing Maps provides filled map shapes for locations around the world. Without a valid entry in the Location well, Power BI cannot create the filled map.
Filter the map to display only the continental United States.
a. At the bottom of the Visualizations pane, look for the Filters area.
b. Hover over State and click the expand chevron
c. Place a checkmark next to All and remove the checkmark next to AK.
Select SalesFact > Sentiment to add it to the Color saturation well. The field in the Color saturation well controls the map shading.
The filled map is shaded in blue, with light blue representing the lower sentiment numbers and dark blue representing the higher, more-positive sentiment. Here I've highlighted the state of Wyoming (WY) and see that Sentiment is very good, 74.
For information about using the Filters pane, see Add a filter to a report.
Highlighting a Location in a Filled Map cross-filters the other visualizations on the report page... and vice versa.
On the filled map, select a state. This highlights the other visualizations on the page. Selecting Texas, for example, shows me that Sentiment is 74, Texas is in the Central District #23, and that most of the sales volume comes from the Moderation and Convenience segments.
On the line chart, toggle between No and Yes. This filters the Filled Map to show Sentiment for VanArsdel and for VanArsdel's competition.
Map data can be ambiguous. For example, there's a Paris, France, but there's also a Paris, Texas. Your geographic data is probably stored in separate columns – a column for city names, a column for state or province names, etc. – so Bing may not be able to tell which Paris is which. If your dataset already contains latitude and longitude data, Power BI has special fields to help make the map data unambiguous. Just drag the field that contains your latitude data into the Visualizations > Latitude area. And do the same for your longitude data.
If you have permissions to edit the dataset in Power BI Desktop, watch this video for help addressing map ambiguity.
If you do not have access to latitude and longitude data, follow these instructions to update your dataset.
For more help with Map visualizations, see Tips and tricks for map visualizations.
Add a visualization to a report
Visualization types in Power BI Change the type of visualization being used Pin a visualization to a dashboard
Power BI - Basic Concepts
Try it out -- it's free!
More questions? Try the Power BI Community