Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I've created a shape map, but it does not recognize Singapore and Taiwan.
- Tried ISO Alpha 2 & 3 too. Not successful.
Solved! Go to Solution.
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
@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! 😉
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
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.
Hey @achin1979 ,
thank you for sharing the file.
Did you inspect the json file, using a simple text search for Singapore?
I realized that Singapore is not contained in the countries-110m.json file that you will find here: GitHub - topojson/world-atlas: Pre-built TopoJSON from Natural Earth.
Maybe this is the same reason with your file.
Hopefully, this provides some new ideas on how to tackle your challenge.
Regards,
Tom
Thanks, @TomMartens
I did. Singapore, Hong Kong & Taiwan are all there. I'm new to json.
Is that mean it's not possible to have them & better to change to another type of map?
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
@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! 😉
Hey @achin1979 ,
if it's a public JSON file you might consider adding the source as it will happen others as well. If you created the arcs yourself, consider providing a short description of how you did it, e.g. using qGIS
Regards,
Tom
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |