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

15. Maps: Showing Maharashtra on a Map

15.4 Latitude and Longitude for Dark Stores

By Last updated:

In short: Two Pune dark stores, Kothrud and Baner, both appear as one Pune bubble.

Start with a problem

Two Pune dark stores, Kothrud and Baner, both appear as one Pune bubble. Ravindra needs a bubble for each store.

Explain simply

Latitude (north–south position) and Longitude (east–west position) give an exact point, so no geocoding is needed. Set their data categories so the map uses them.

Show the data

Store City Latitude Longitude Total Sales (₹)
Kothrud Pune 18.5074 73.8077 650
Baner Pune 18.5590 73.7868 200
Gangapur Nashik 20.0110 73.7650 300
College Road Nashik 20.0059 73.7629 500
Rajarampuri Kolhapur 16.6950 74.2430 450

About this data: This table uses columns: Store, City, Latitude, Longitude, Total Sales (₹). This table uses columns: Store, City, Map result. This table uses columns: Store, Latitude, Longitude, Map result. 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. Load dark_stores_maharashtra.csv and relate Stores[Store] to Orders[Store] (one-to-many).
  2. Set Data category: Latitude → Latitude, Longitude → Longitude; Summarization Don't summarize.
  3. Insert Map: Latitude Latitude, Longitude Longitude, Bubble size Total Sales, Tooltips Store.
  4. Zoom into Pune to see two separate bubbles.

Show the result

Your result should look like this (fictional sample):

Store City Latitude Longitude Total Sales (₹)
Kothrud Pune 18.5074 73.8077 650
Baner Pune 18.5590 73.7868 200
Gangapur Nashik 20.0110 73.7650 300
College Road Nashik 20.0059 73.7629 500
Rajarampuri Kolhapur 16.6950 74.2430 450

Explain what happened

Each store has its own coordinates, so each becomes its own point. The bubble size is Total Sales filtered to that store through the relationship.

Explore further

  • Coordinates in this file are approximate area points for teaching, not exact store addresses.

Detailed reference for this lesson:

Latitude and longitude on a Power BI map with example — in 30 seconds

What: Latitude and longitude are exact map points. With them, Power BI does not have to guess where a place is.

Why: Some place names exist in more than one state. Power BI may put the dot in the wrong state.

Tiny example: A store with only "Aurangabad" can land in Bihar. With latitude 19.876 and longitude 75.343 it sits in Sambhaji Nagar.

First look at the data (before, then after):

Latitude and longitude on a Power BI map with example: before and after tables, fictional Blinkit Maharashtra data

Same before / after tables as text

Before — DarkStore — city text only

Store City Map result
Kothrud Pune Correct
Cidco Aurangabad Wrong state (guessed)
Dharampeth Nagpur Correct

Formula / click path

Column tools › Data category › Latitude (and Longitude)
Map: Latitude = DarkStore[Latitude] · Longitude = DarkStore[Longitude]

After — DarkStore — with map points

Store Latitude Longitude Map result
Kothrud 18.507 73.807 Correct
Cidco 19.876 75.343 Correct
Dharampeth 21.140 79.064 Correct

Do it step by step:

  1. Add Latitude and Longitude columns to DarkStore as decimal numbers.
  2. Select DarkStore[Latitude]. In Column tools, set Data category = Latitude.
  3. Select Longitude. Set Data category = Longitude. Set both to Don't summarize.
  4. Add a Map visual. Drag Latitude and Longitude to their wells.
  5. Drag [Total Orders] to Bubble size.
  6. Check that every dot is inside Maharashtra.

The most accurate way is to store coordinates for each dark store. Get them from the store master data or a maps application (right-click the location). Always keep decimal degrees with enough precision (4–6 decimals).

Store ID Store Name Area City Latitude Longitude
BLK-PUN-KOT-01 Blinkit Kothrud Hub Kothrud Pune 18.507 73.807
BLK-PUN-HIN-01 Blinkit Hinjewadi Hub Hinjewadi Pune 18.591 73.738
BLK-NGP-DHP-01 Blinkit Dharampeth Hub Dharampeth Nagpur 21.139 79.063
BLK-NSK-CRD-01 Blinkit College Road Hub College Road Nashik 20.007 73.763
BLK-KOP-RJP-01 Blinkit Rajarampuri Hub Rajarampuri Kolhapur 16.699 74.237
BLK-MUM-ADH-01 Blinkit Andheri East Hub Andheri East Mumbai 19.114 72.870
BLK-SAM-CID-01 Blinkit CIDCO Hub CIDCO Sambhaji Nagar 19.877 75.365

(Approximate, rounded coordinates of the areas, for practice only. The stores are fictional.)

Latitude vs longitude

Maharashtra is at about 15.6° to 22° North latitude and 72.6° to 80.9° East longitude (रेखांश). If your bubbles appear in the ocean or in another country, you have probably swapped the two columns, or the values were read as text.

Ravindra Bagale's Tip

Friends, many students store latitude and longitude as text, or rounded to two decimals, so bubbles stack up or land about a kilometre away. Keep them as decimal numbers with four to six decimal places and set the data categories Latitude and Longitude. Practise, and it will feel very easy.

Fix common mistakes

Wrong result Reason Correction
All stores stacked at one point Latitude/Longitude summed (Sum of Latitude) Set Don't summarize, or use Average
Bubbles in the sea Latitude and Longitude swapped Latitude is ~16–21 for Maharashtra, Longitude ~73–80
Bubble size equal for all No relationship to Orders Create the Stores, then Orders relationship

Practise independently

Practice task

Which two stores are in Nashik and what are their bubble values?

Hints
  • Latitude about 20.0.
Solution

Gangapur ₹300 and College Road ₹500.

Think like a professional

Coordinates are master data. Keep them in a store dimension owned by operations, not typed into a report.

Ravi Sir's Cards for this lesson

Latitude and longitude for dark stores. A dark store is a small warehouse for quick delivery. Many stores share one city name, so a city name cannot place each store.Revision card

मराठी cards