Forum Discussion

rohitMe's avatar
rohitMe
Advocate I
8 years ago
Solved

Incorrect map location

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

Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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