cancel
Showing results for
Did you mean:
Regular Visitor

## Lat/Long Coloring/layering Bubbles

I have a set of 1,000 companies with lat/long coordinates, each assigned a different index value from 0-9. I have plotted each of the coordinates with success using different colored bubble in the legend.

 CUSTOMER INDEX LATITUDE LONGITUDE 1004050 4 42.61938 -83.0321 1009252 4 34.8586 -82.3955 1010250 5 36.07659 -80.1817 1007132 5 35.89308 -78.8645 1002161 6 39.98421 -82.8698 1008239 6 35.89308 -78.8645 1000801 7 39.98421 -82.8698 1007199 7 35.89308 -78.8645 1002539 8 33.90199 -118.387 1007905 8 39.98421 -82.8698 1008515 8 35.89308 -78.8645 1001924 9 39.98421 -82.8698 1006311 9 39.98421 -82.8698 1010409 9 35.89308 -78.8645

However, when I have multiple companies at the exact lat/long with a different index, it is giving me a pie-chart type bubble. Is there a work around so I can have 1 bubble for each index color on/around that coordinate (doesn't have to be perfect location)? Perhaps a formula for using an approximation for the lat/long?

Carly

2 REPLIES 2
Highlighted
Community Support Team

## Re: Lat/Long Coloring/layering Bubbles

Hi Carly,

As we can see from the sample data, there is a scenario that one pair of lat/long has many customers. I afraid we can't display one place as many bubbles. If it's possible to make little changes in the lat/long?

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Lat/Long Coloring/layering Bubbles

Hi Dale, thanks for responding. These are likely customers all located at the same location, like a large office building or mall. We could make tiny modifications (would have to do this in Power BI), but what if we have a large number of companies at the same location, would it still be feasible?