Forum Discussion
Helper IMap visualisation
Hi Fabiann ,
Yes you are right. Looking at the map bahaviour, I would suggest changing United States of America to USA.
After doing some more investigation, I found a blog where it refers to a standard link for country names:
Blog: https://blog.ailon.org/how-to-display-2-letter-country-data-on-a-power-bi-map-85fc738497d6
Standard country names & codes: https://en.wikipedia.org/wiki/ISO_3166-1
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Helper IThank you Pragati for your help and support so far, very kind of you.
I have changed the modelling for Country as "Country/Region", the list has 43 records in "United States of America" then to test I have changed one record to be USA and refresh data, and I have a strange behaviour
Obviously the Stacked Bar chart is showing "United States of America" = 42, and then "USA" = 1, which is normal, text label for country.
But you see the map below is showing now USA with one record, as before it was showing 43 records while Country = "United States of America".
Hence the reason I was looking for the list of countries that the visualization is using, I don't know if it is Bing or something else.
But surely it is using the text data to pin the record on the map.
Super UserHi Fabiann ,
Yes you are right. Looking at the map bahaviour, I would suggest changing United States of America to USA.
After doing some more investigation, I found a blog where it refers to a standard link for country names:
Blog: https://blog.ailon.org/how-to-display-2-letter-country-data-on-a-power-bi-map-85fc738497d6
Standard country names & codes: https://en.wikipedia.org/wiki/ISO_3166-1
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
- Fabiann
Many thanks!!
Used the ISO-3366-1 and worked fine