Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a lat long file for the Indian geolocation.
Want to calculate the distance between the geo-locations in the same territory. Data is available for Region, Branch, and territory. Where Region is the highest level of hierarchy and Territory is the lowest level of hierarchy.
1) I want to calculate the distance between each lat long in a territory.
2) Want to highlight data points in a 3 km radius from a selected lat-long.
The sample data points:
Region | Branch | Territory | Dealer Code | Latitude | Logitude |
A | aa | aaa | 002D000029 | 25.45145 | 81.87366 |
A | bb | bbb | 002D000048 | 25.47273 | 81.85761 |
A | cc | ccc | 002D000084 | 25.44915 | 81.7614 |
A | dd | ddd | 002D000165 | 25.45609 | 81.87309 |
A | aa | abc | 002D000192 | 25.45697 | 81.87075 |
A | cc | cde | 002D000196 | 25.48831 | 81.8486 |
A | cc | efg | 002D000222 | 25.46542 | 81.85095 |
A | dd | dfg | 002D000295 | 25.52968 | 81.85361 |
B | zz | zzz | 002D000298 | 25.46234 | 81.85505 |
B | yy | yyy | 002D000308 | 25.49461 | 81.86021 |
B | mm | mmm | 002D000318 | 25.62312 | 82.00485 |
B | zz | xyz | 002D000541 | 25.46616 | 81.85084 |
B | yy | yzm | 002D000649 | 25.45073 | 81.78039 |
B | yy | zyq | 002D000666 | 25.45731 | 81.87041 |
B | mm | mpq | 002D001070 | 25.45398 | 81.86141 |
The issue is resolved using ArcGSI Maps for Power BI. Thank you, Amit for your efforts.
The actual file contains more than 40K lat-longs.
@BhoomiT , refer if these 2 can help
https://radacad.com/dynamic-distances-in-power-bi
Thank you for your response.
I have calculated the distance in a measure. But I am not able to create a slicer using the measure.
How to create a visual that provides 3 km radius from a selected lat-long?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |