Forum Discussion

achin1979's avatar
achin1979
Frequent Visitor
4 years ago
Solved

ISO Country Code : Country undefined

I've created a shape map, but it does not recognize Singapore and Taiwan.

- Tried ISO Alpha 2 & 3 too. Not successful.

  • Hey achin1979 ,

     

    if I open the global_dot_json inside a text editor, I can't find Singapore if I'm searching for the text "Singapore"

    There is just a fraction for what is necessary to visualize Singapore, Alpha code 2 "SG"

    In contrast this is inside the JSON for Germany

    {
                        "arcs": [
                            [
                                223,
                                224,
                                -221,
                                -44,
                                -163,
                                225,
                                226,
                                -57,
                                227,
                                228,
                                229
                            ]
                        ],
                        "type": "Polygon",
                        "properties": {
                            "name": "Germany",
                            "Alpha-2": "DE"
                        },
                        "id": "DEU"
                    },

    And this is SG:

    {
                        "type": null,
                        "properties": {
                            "Alpha-2": "SG",
                            "Alpha-3": "SGP"
                        }
                    },

     

    The json file is missing essential information, this is the reason why SG will not be visualized.

     

    Regards,

    Tom

     

  • achin1979's avatar
    achin1979
    4 years ago

    TomMartens Thanks for pointing it out. I've reloaded new json file with arc for those missing countries. It's working now. Thanks a lot! 😉

7 Replies

  • Hey achin1979 ,

     

    please take the time and create a pbix file that contains sample data. Upload the file to to onedrive or dropbox and share the link.

    Please describe what is your expected result and also mention what map visual you are using.

     

    Regards,

    Tom

    • achin1979's avatar
      achin1979
      Frequent Visitor

      A shape map cannot show country locations like Taiwan, Hong Kong, and Singapore.

       

      Suspect Hong Kong has returned to China, hence no longer displayed as a country on its own?

      Singapore is missing from the Shape map, and Taiwan is not detectable. 

       

       

      But all works well with Filled Map which is not something I need. 

      TomMartens ,  PBIX file (right click to download)