One of the things I like about Power BI is, it supports geospatial visualizations. Map and Filled Map are built-in visualizations we can use if we need a visual with geographic coordinates. But it's not perfect, like everything else, it has some issues. I will explain the issue that I have faced and of course the solution to it. On the map, I visualize sales by city and France is filtered. Despite France is filtered, it shows some cities in the USA. In the beginning, I didn't understand what caused it, but later I have noticed that both countries have cities with the same name and that's the reason for my problem. Somehow, Power BI can't decide which city I meant to see despite I filter by country and shows all the cities with the same name on the map. The first solution is using latitude and longitude data, but of course, if you have it. I had that data and it solved my problem but I am also going to explain what to do if you don't have latitude and longitude dat...
A blog about solving the problems that we face, while we're creating Power BI reports.