Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
gauravphadke
Frequent Visitor

how to plot multiple latitude and longitude from a flattened table?

How do I plot multiple latitude and longitude values from a single row? 

 

Scenario: 

 

  • I have a single flattened SHIPMENT table.
  • There is unique row (record) for each TRIP within the SHIPMENT table. Every trip record has Pickup latitude and longitude as well as Delivery latitude and longitude.
  • How do I plot Pickup and Delivery Lat Long for all the trips in SHIPMENT Table?

Please help me out here.

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @gauravphadke ,

 

Please elaborate your scenario with sample data and expected output.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Use Case:

 

I have a unique TRIP ID. One row in sample data represents one TRIP. One TRIP consist of multiple zones (loading zone, road zone, delivery zone, docking zone). Each and every zone has its own latitude and longitude values. I want to plot the latitude and longitude values of each and every zone on a map showing the entire trip (loading zone --> road zone --> delivery zone --> docking zone).  

 

Here is some sample data:

TRIP IDLoading ZoneLoading zone start timeLoading Zone End TimeLoading Zone LatitudeLoading Zone LongitudeRoad Zone Road Entry Start TimeRoad Entry End TimeRoad Entry LatitudeRoad Entry LongitudeDelivery ZoneDelivery Zone Start TimeDelivery Zone End TimeDelivery Zone LatitudeDelivery Zone LongitudeDocking ZoneDocking Zone Start TimeDocking Zone End TimeDocking Zone LatitudeDocking Zone Longitude
10118:21 AM8:26 AM33.085502-96.83559918:27 AM9:30 AM-96.82721833.08453419:32 AM9:58 AM33.0826738-96.8274369110:00 AM10:30 AM33.084534-96.826054
10219:21 AM9:52 AM33.085502-96.835599110:20 AM3:21 PM-96.82721833.08453413:22 PM4:14 PM33.0826738-96.827436914:30 PM5:00 PM33.084534-96.826054
10317:38 AM7:45 AM33.089125-96.82721818:27 AM9:30 AM-96.82721833.08453419:32 AM9:58 AM33.0826738-96.8274369110:00 AM10:30 AM33.089125-96.827218

 

 

Expected Output:

I want to display different TRIPS on a map. Within one trip, individual zones will represent stops on a map. 

 

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors