Ravindra BagaleCourses & study guides

15. Maps: Showing Maharashtra on a Map

15.5 Worked Example: Maharashtra Dark Store Bubble Map

By Last updated:

Steps in Power BI

  1. Click an empty canvas area › Visualizations › Map (or Azure map).
  2. Latitude = DarkStore[Latitude], Longitude = DarkStore[Longitude] (set to Don't summarize or Average; they must not be summed!). Alternatively, Location = DarkStore[Map Location].
  3. Bubble size (Size) = [Total Orders]; Legend = DarkStore[City] or Orders[Platform]; Tooltips = Avg Delivery Time (mins), Cancellation Rate, Store Name.
  4. Format visual › Visual › Map settings › Style (Road, Aerial, Dark, Light, Grayscale) › Auto zoom On. Turn on the zoom buttons if available.
  5. Bubbles › Size slider to avoid overlapping Pune stores; Colors › fx for conditional colour (red when Avg Delivery Time > 15 mins, Module 20.6).
  6. Category labels › On (shows the store names; turn off if crowded).
  7. Add a slicer for Platform and a card for the selected city's orders. Use Edit interactions so the map filters the cards.

Filled map with colour saturation: Location = District (data category County or Place), then Format › Visual › Fill colors › fx › Format style Gradient › based on Total Orders (light yellow → dark green). With colour saturation, darker areas have more orders.

Heat map for customer density

He bagha: in the Azure map, add a Heat map layer with customer latitude/longitude (for example drop locations around Baner, Wakad and Hinjewadi). Use it to decide where the next Pune dark store should open. Use approximate or anonymised locations to protect customer privacy.

Ravindra Bagale's Tip

A common mistake is using bubble size for a measure with a huge range, so one Pune store hides all the others. Adjust the bubble size range in the format settings, or use colour for the measure and a fixed size. Always add a tooltip with the store name and key numbers. Never forget this.