In Power BI reports to gain deeper insights using the geographical data then we use filled maps feature. Filled map not only show data distribution across regions but it also helps in analyze patterns or trends. Let’s see how to create a filled map further in this blog.
How to Proceed?
Step 1
Launch power BI desktop app and open the new report page and import the data required.
Step 2
In “visualizations” pane click on “Filled Map” which is highlighted in the given figure.
Step 3
Drag the data fields into “Field Section” that you want to analyze.
Location: Specifies information that defines geographic locations that includes city names, country/region names, Postal codes to be displayed on the map – Region.
Legend: Provides an explanation about the category used on the map. - Medal
Latitude and Longitude are the coordinates values which locate a specific location. Here we don’t have any coordinates value
Tooltips: add more information to the visual- No of medals
Step 4
Customizing the appearance
You can customize the appearance of the Map visual. Click anywhere on the visual and set the properties in the Format section.
"Map Settings" options allows you to customize and configure various aspects of map visuals within your reports.
The map settings include a "Style" option that enables users to choose the map type such as Road, Aerial, Dark, Light and Grayscale, along with “Controls" option that provides control over features like zoom, lasso selection, and auto zoom buttons with toggles for activation.
“Geocoding culture” allows you to specify the regional or cultural context for interpretation of data. It ensures accurate map labelling according to your chosen language-region preferences
Legend option enables you to customize the position, font style, and colour scheme of the legend displayed within the map visual
Fill colors we can customize specific color for the field used in the legend section.
Step 5 Save the visual
Finally, your Filled Map is ready. Click save button to save the visual.
When to use Filled Map visual?
Both Map and filled map visual are same the only differences is their type of representation and it differs based on the use cases. While map visual shows as specific data points whereas the filled map displays data using filled regions, instead of individual data points it uses shaded or colored region for the aggregated data.
You can use Filled Map visual for following scenarios
- When your dataset includes location-related data, such as latitude and longitude coordinates, city names, postal codes, or country names.
- When you need to compare data across different locations or regions, a map visual allows for quick and visual comparisons.
- To highlight the patterns or variations
Pros
- Maps are visually appealing and can make data presentations more interesting and informative.
- Maps offer users a straightforward grasp of the locations of events or data points.
Cons
- Map visuals are less effective when dealing with complex or dense datasets.
- Map visuals depend on the accuracy and completeness of the data for meaningful representation.
Conclusion
Filled Map in Power BI can be used when our analysis involves aggregated data at a higher geographical level and we want to showcase patterns and variations in a metric across different regions. It's an effective visualization technique for understanding the broader geographical context of our data.
| Tags | Power BI |
| Useful links | |
| MS Learn Modules | |
| Test Your Knowledge | Quiz |
No comments:
Post a Comment