cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sotoc Regular Visitor
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.

 

CUSTOMERINDEXLATITUDELONGITUDE
1004050442.61938-83.0321
1009252434.8586-82.3955
1010250536.07659-80.1817
1007132535.89308-78.8645
1002161639.98421-82.8698
1008239635.89308-78.8645
1000801739.98421-82.8698
1007199735.89308-78.8645
1002539833.90199-118.387
1007905839.98421-82.8698
1008515835.89308-78.8645
1001924939.98421-82.8698
1006311939.98421-82.8698
1010409935.89308-78.8645

 

2018-03-20_9-04-24.png

 

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? 

 

 

2018-03-20_8-53-48.png

 

Thanks in advance,

Carly

2 REPLIES 2
Community Support Team
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?

Lat_Long_Coloring_layering_Bubbles

 

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.
Highlighted
sotoc Regular Visitor
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?