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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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