Forum Discussion
Not all PBI Lat Long coordinates displaying
Community SupportAnonymous ,
Power BI uses Bing's unstructured URL template service to get the latitude and longitude coordinates based on a set of address values for any country. It seems there's something wrong with your latitude and longitude value which can't be recognized by map visual.
Latitude and Longitude fields must be in Decimal Number format, which you can set in the data model, please check it. You need to drag the field that contains your latitude data into the Visualizations > Latitude area. And do the same for your longitude data. When you do this, you also need to fill the Location field when creating your visualizations. Otherwise, the data is aggregated by default, so for example, the latitude and longitude would be paired at the state level, not the city level.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Jimmy for the reply. Yes the Lat Long is in a decimal format, and I have tried up to 8 decimal points. I have also tried the location as well but then creates and error. The odd thing is when I filter down to a specific location all the lat long locations then are displayed thus the data looks to be fine but the system is not able to display all the records at once. Re the aggregate, it does not look to following any aggregate pattern at state of city level as it looks to filter randomly, but I know this would not be the case and just trying to understand what logic it is following.