Recently while creating a map report on Power BI where I had to plot a set of latitude and longitudes on it. But I was not able get the desired result. When I put the latitude and longitude values in the place holders, it was automatically giving me the count or latitude or longitude.
![]()
My initial reaction was it was due to the datatype of the columns, so I checked it. It was latitude and longitudes as needed. After going through a couple of ways to fix this problem, this is the final solution that I found.
I created a new column named location where I concatenated latitude and longitude in a single string.
Location = 'TableName'[Latitude]&","&'TableName'[Longitude]
And then instead of using latitude and longitude, use this new column in the location place holder. This then plotted all the geo-coordinates are required.
![]()
Here is the before after images of the map.
Before
![]()
After
![]()