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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Reg0
New Member

Set radius circle around map location

Hi all,

 

I have a list of 25 locations across the UK and I'm looking to produce a distance bubble of 20 miles around each of them. I've seen that is possible to do this to a degree with ArcGIS but it does not allow 25 separate locations. I also get a permissions issue when trying to use ArcGIS.

 

Is there any other map visual that allows this? I'm thinking that the standard map visual has the 'size' field. Could this be used?

 

Thanks,

Reg

2 REPLIES 2
cholton
Frequent Visitor

I wanted to do this for the U.S. using free tools built into Power BI. Whether this method works for other countries will depend on whether the sort of distance file I started with is available or can be created. If you have latitude and longitude for the center of all areas of interest, you can use a measure in PowerBI to find the distances using the Haversine formula without the need for a file where the distances are already recorded. I found that the U.S. National Bureau of Economic Research offers a file with calculated distances from every U.S. county (FIPS code) to every other U.S. county. Using this list of paired locations with distances, I used this method:

  • Leave the first division (county FIPS) list unaltered
  • Merge second division list with divisions/locations of interest 
  • Create a conditional column based on whether the distance bewteen divisions provided in the file is within the bubble range, in your case 20 miles. For my need, I used three distance ranges for the conditional column to produce two circle colors and color the background a third color.
  • If you want the center of the bubble to be a different color, append a list of the divisions of interest with the distances set to zero from themselves and the conditional column value set to whatever you want to call your locations in the map legend
  • To keep only the minimum distances, sort the rows ascending by distance and then remove duplicates
  • On the pre-loaded, free Azure map, use the conditional column as your legend
lbendlin
Super User
Super User

The size field can be used but there is no way to set it to "20 miles" . You can only specify the pixel radius.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors