Forum Discussion

minhln's avatar
minhln
Regular Visitor
10 years ago
Solved

Create Map Visuals Vietnam

I tried to create a filled/map visuals by provinces/cities of Vietnam, which using ISO 3166-2:VN and/or from stoids.com/uvn.html. However, the visual shows not correct or not full provinces of Vietna...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Minh,

    From your pbix file, it seems that Bing map mixes the Ha Nam Province and a Province in China. To help Bing identify the location correctly, please provide specific latitude and longitude along with Province, then check the map visualization.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Minh,

Could you please post a screenshot to show the map visualization and fields you are using? And we will appreciate that if you can mark the specific area which doesn’t show correctly in the map visual.

In addition, Power BI uses Bing to geocode the data, make sure that you follow the instructions in this article to properly create the map visual.

 

Thanks,
Lydia Zhang

minhln's avatar
minhln
Regular Visitor
10 years ago

Hi Lydia,

 

Thanks for your advice. I will follow the instructions which I think I will combine both province names and Long&Lat data and update result later.

 

Btw, kindly find the working pbix file as below.

 

https://onedrive.live.com/redir?resid=44685F526CE797F9%21119626

 

The first source I used from wiki https://en.wikipedia.org/wiki/ISO_3166-2:VN , the ISO Code is not working. However, the output used Province Name is most accurated (except for Ha Nam Province, which moved to China as below screenshot).

 

 

 

The second source (from http://www.statoids.com/uvn.html), I tried HASC, ISO, FIPS... but outputs are not correct. Again, province name is better choice compared with the others. (Below screenshot).

 

\

 

Thanks

Minh

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Minh,

    From your pbix file, it seems that Bing map mixes the Ha Nam Province and a Province in China. To help Bing identify the location correctly, please provide specific latitude and longitude along with Province, then check the map visualization.

    Thanks,
    Lydia Zhang

    • minhln's avatar
      minhln
      Regular Visitor
      10 years ago

      Hi Lydia,

       

      It worked fine with the province names and Long&Lat.

      Thanks a lot!

       

      Best Regards,

      Minh