Please respond in the appropriate window, currently you are sometimes typing text in a preformatted text window.
With the addition of N or W they cannot be in decimal format.
Basically in the background a mapping visual will convert the adress information into latitude and longitude and plot on a map.
Your records show a latitude and longitude, this means they have been geographically coded, which is the best way to map, so I assumed these to be correct but many are not.
However, when I use your cities I get the city map shown next, blue dots,
when I map your latitude and longitude I get a totally different map, yellow dots.( I used Mapbox visual, which I find much better, available free in the AppStore), so it is likely something is wrong with the data.
I had a closer look at your data, to find that every records shows the same country and city in the column “City Country”
I have added a merged column “Location” in Power Query, with city and country separated by a comma. This mapped more accurately.
The Excel file shows the latitude longitude from a GIS application next to your information.
The PBI file shows the data mapped.
Mapping issue.pbix (414.3 KB) Power BI map issue converted Layer.xlsx (76.7 KB)
Hope this helps