Ravindra BagaleCourses & study guides मराठी Track your progress

14. Visuals and Their Formatting

14.12 Map, Filled Map, Shape Map and Azure Map (Summary)

Start with a problem

Raja wants to show the three cities on a map instead of a bar chart.

Explain simply

Power BI has several map visuals: Map (bubbles), Filled map (shaded areas), Shape map (custom region shapes) and Azure Maps. Maps need location fields Power BI can understand – Module 15 covers this fully.

Show the data

City Region Total Sales (₹)
Pune West Maharashtra 850
Nashik North Maharashtra 800
Kolhapur South Maharashtra 450

About this data: This table uses columns: City, Region, Total Sales (₹). This table uses columns: Visual, One-line summary. This table uses columns: Wrong result, Reason, Correction. Values shown are the lesson examples already on this page (not a new dataset).

Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv, dark_stores_maharashtra.csv (source: src/practice/).

Demonstrate

  1. Make sure map visuals are enabled (Module 15.2).
  2. Select City › Column tools › Data category › City.
  3. Insert Map (or Azure Map): Location City, Bubble size Total Sales.
  4. Hover each bubble to read the value.

Show the result

Map bubbles by sales, schematic outline with fictional data

Your result should look like this (fictional sample):

Three bubbles: Pune largest (₹850), Nashik (₹800), Kolhapur smallest (₹450).

Explain what happened

Power BI sends the city names to the map service to find their positions (geocoding – turning a name into a place on the map), then sizes each bubble by the measure.

Explore further

  • Add State and Country, or use latitude and longitude, to avoid wrong matches.

Detailed reference for this lesson:

Visual One-line summary
Map (bubble) Bubbles at locations, sized by a measure
Filled map Colours whole areas (states/districts) by value
Shape map Colours regions from a custom TopoJSON map (preview feature)
Azure map Modern map with layers (bubble, heat map, 3D columns, reference layers)

Module 15 covers maps fully, including geocoding (नावावरून नकाशावरील जागा ठरवणे), data categories, latitude (अक्षांश)/longitude and the settings needed to enable map visuals.

Ravindra Bagale's Tip

Remember one thing: a frequent mistake is using the filled map for city points, but it colours regions, not points. Use a bubble map (Map or Azure Map) for city and store points, and filled or shape maps for areas like districts. Module 15 has the details and the geocoding tips. Remember this rule.

Fix common mistakes

Wrong result Reason Correction
Pune shown outside India Ambiguous place name Add State/Country or use Latitude/Longitude
Map visual is grey/disabled Map visuals turned off in options or by admin Enable in Options › Security (Module 15.2)
Bubble sizes look equal Values are close Add data labels or use a bar chart for exact comparison

Practise independently

Practice task

Put the five stores on a map using Latitude and Longitude from dark_stores_maharashtra.csv.

Hints
  • Relate stores to orders on Store.
  • Set data categories Latitude and Longitude.
Solution

Five bubbles: Kothrud ₹650 and Baner ₹200 in Pune; College Road ₹500 and Gangapur ₹300 in Nashik; Rajarampuri ₹450 in Kolhapur.

Think like a professional

Use a map only when location itself is the insight (distance, cluster, coverage). Otherwise a bar chart compares values faster.

Ravi Sir's Cards for this lesson

मराठी cards