Forum Discussion

sotoc's avatar
sotoc
Icon for Advocate I rankAdvocate I
8 years ago

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

 

 

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? 

 

 

 

Thanks in advance,

Carly

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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

    • sotoc's avatar
      sotoc
      Icon for Advocate I rankAdvocate I
      8 years ago

      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?