Some datapoints are not displayed on a map chart, how to find out which ones?

[philippe_mikron]

I am trying to display a list of customers on a map chart using data coming from Salesforce. Most of the cases seem to be displayed correctly, but some datapoint are not displayed on the map (I assume because the dataset needs some cleaning).

Is there any way to list or highlight the missing datapoints so I can quickly identify which data to cleanup in the original dataset?

Thank you for your help

[v-luwang-msft · Accepted solution]

Hi  @philippe_mikron 

On the top left of your visual is there a little ! mark usually that means there are too many points to display.

similar error refer:

https://community.powerbi.com/t5/Desktop/Map-is-not-showing-all-data/m-p/290002 

Best Regards

Lucien

[PhilipTreacy]

Hi @philippe_mikron 

I can't think how you can find data points that are not displayed on your map.  If it's not displayed, there's no way to look at the map and go "that's missing".  You'll have to go through each data point in the source data.

Maybe if you can post the data it might be possible to identify data in the correct format (and displayed) and then look for data that is not in that format.

Regards

Phil