Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
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:
The size field can be used but there is no way to set it to "20 miles" . You can only specify the pixel radius.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
80 | |
76 | |
61 | |
36 | |
32 |
User | Count |
---|---|
91 | |
60 | |
59 | |
49 | |
45 |