Points on Map only show top percentage of data

I’m using the ‘points on map’ visual. I noticed that Quicksight was only showing parts of my data. I notice the sub heading “showing TOP 227 in Lattitude, Longitude… etc”.

These numbers seem to change, some examples showed about half of the expected data, others show about 90%. It seems to max out at a hard limit of 5000, however most of my data sets are much smaller than that and it still seems to limit the number.

Can someone please explain this to me? How can I turn it off and show all my data?

Field Wells

Thank you :slight_smile:

Hello @damien thanks for posting into the community.

I see you are using latitude and longitude to position points in map. Also I see that top 227 in latitude are being shown which is way under the display limit of 10K datapoints, so here the only options I see for this behavior are:

  1. Filters that could be affecting your data (I guess that you already checked that, but always worth to check)
  2. Incorrect (invalid) lat/lon combinations (this could be one of the most common reasons)
  3. Missing data in the size (measure) field that makes the corresponding point in map (lat/lon and/or tag) not be graphed

Here my recommendation would be to check these points being number 2. the most common, in order to see if the data points you have are valid you can click on the :round_pushpin:button that you have in the visual menu to see if there is any invalid/missing data so you can debug it, below you can find a similar example with filled maps:

Hope it helps, please mark this solution as solved if that’s the case also to help other members of the community., otherwise let us know.

Happy dashboarding!


Hi @EnriqueS, thank you for the detailed response. It was very helpful.

I followed through your suggestions and, in the process found that the issue was that I had some identical (down to 7th decimal place) latitudes and longitudes in the set. Quicksight was correctly aggregating them.

Thanks for your help!!

1 Like

Hello @damien thanks for your response and feedback, glad to see it was solved.

Very welcome! Regards.

1 Like