Friday, January 05, 2024

Lesson 36 - Filled Map in Power BI Desktop

A Filled Map visual is used to display aggregated data across geographical regions by shading or coloring areas on a map. It helps identify patterns, compare regions, and visualize geographical trends more effectively.


Note: Microsoft recommends using the Azure Maps visual for new reports because it provides enhanced mapping capabilities and additional geographic features. Microsoft is moving Power BI mapping experiences from the older Map and Filled Map visuals to Azure Maps. Existing Filled Map visuals can be converted to Azure Maps in Power BI Desktop. If the classic Filled Map visual is not available in the Visualizations pane, select More visuals (...) → Restore default visuals.


How to Proceed?


Step 1
Launch power BI desktop app and open the new report page and import the data required. 


Step 2

In the Visualizations pane, click the Filled Map visual. If the Filled Map visual is not available, click More visuals (...) → Restore default visuals to restore the classic Filled Map visual.










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 coordinate values used to identify a specific geographical location. Since our dataset already contains region names, we do not need to provide latitude and longitude values.

Tooltips: add more information to the visual- No of medals

Step 4

Customizing the appearance

You can customize the appearance of the Filled 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 allow you to customize the colors used for each category displayed on the map.









Step 5 Save the visual

Finally, your Filled Map visual is ready. Click Save to save the report.











When to use Filled Map visual?


Both Map and Filled Map visuals are used to display geographical data, but they represent data differently. A Map visual displays individual locations using bubbles, whereas a Filled Map visual shades entire geographical regions based on values or categories.

A Filled Map visual is useful when:
  • Your dataset contains geographical data such as countries, states, regions, or postal codes.
  • You need to compare aggregated values across geographical regions.
  • You want to identify regional patterns, trends, or variations using colors.
  • You want to highlight differences between countries, states, or other geographical boundaries.

Pros

  • Filled Maps make it easy to compare values across geographical regions.
  • Color-coded regions help identify trends and patterns quickly.
  • Suitable for displaying aggregated geographical data.
Cons

  • Filled Maps are less effective when displaying very detailed or dense geographical data.
  • Accurate location data is required for proper mapping.
  • They are not suitable for displaying individual data points.

Conclusion


Filled Map visuals are useful for displaying aggregated geographical data by shading regions based on values. They help identify regional patterns and compare metrics across locations. While Microsoft recommends using the Azure Maps visual for new reports, the Filled Map visual remains a suitable option for basic geographic analysis.

Useful Information

Tags Power BI
Useful links
MS Learn Modules
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
Test Your Knowledge Quiz

No comments:

Post a Comment