Desktop

[sotoc]

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? 

Thanks in advance,

Carly

[v-jiascu-msft]

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

[sotoc]

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?