Incorrect map location

[rohitMe]

Hi all,

I was using the map visualisation to map the cities of India and I found that since there are many states and cities around the world with the same name they are not always mapped correctly(or according to what is required). I know I can get around this issue by using the postal codes or lattitude and longitude details(Which is not available in my dataset). But I want to know whether there is way by using filters or something by which I can sort out this issue.

Thanks and Regards

Rohit

[v-yulgu-msft · Accepted solution]

Hi @rohitMe,

You can use the "Full Address" as location. That is to say, combine country and city into a single column, like "CHENNAI, India", "Noida, India". You need to new a calculated column:

Full Address=TableName[City]&","&TableName[Country]

Best regards,

Yuliana Gu