Forum Discussion

Laraib_Ghafoor's avatar
Laraib_Ghafoor
Regular Visitor
9 years ago

Distance between 2 locations

Hi,   I have Location Code, Location Name, Longitude, Latitude, Revenue data in an excel. I have plotted those locations on the bubble map in Power BI. I want that when a user selects 2 locations f...
Need Help
Laraib_Ghafoor's avatar
Laraib_Ghafoor
Regular Visitor
9 years ago

hi Phil_Seamark, Thank for your response !!!

 

I have 30 region offices and around 2000 collection centers. I have made 2 slicers (one for region offices and one for collection centers). I want that when user selects a region from one slicer and a collection center from another, than calculated distance is displayed somewhere on the screen. How can this be done ?

 

My table looks like :-

 

Location Name     Region      Longitude   Latitude

Location1                Region1    12345           56789

Location2                Region1    12345           56789

Location3                Region2    12345           56789

Location4                Region2    12345           56789

 

How can i relate this new calculated measure with the slicers where i click the locations ?

 

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Laraib_Ghafoor

 

The algorithm I used is only based on direct lines and does not give you a distance based on road distance.

 

Otherwise, all it needs is a table of locations as you posted and it should work.

 

You are welcome to pm me some data if you want to keep the locations private and I can build into a PBIX file using the measure I previously posted.