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 IIn the Visualizations pane this is the simple one called "Map". The source of the data has a field called "Country" and nothing else.
However, depending the way you name the country, it appears correctlyt or not.
If you enter "USA" or "U.S.A." versus "United States of America", then it doesn't appear properly.
We have to make sure the entry is "United States of America", so in order to avoid that, we want to offer a drop down list as data entry rather than free text, so we need the full list of country that the visualization "Map" is using.
Super UserHi Fabiann ,
When I click on this visual, I see that it uses - Latitude, Longituge as inputs.
In order to create this visualisation using your data, you atleast need Latitude & Longitude in your data.
Did you try moving "Country" name to Location?
If it works, in that case you will have to correct your data in order to get U.S.A same as USA.
Can you post a screenshot with the map created by you using COUNTRY name?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
- Fabiann
As you can see below, I just use the Country as location.
What I am looking is "what is the list of country that the Map visualization is using"?
Does that make sense?If the data is "United States of America" then it works, if it is for example USA, then it doesn't work.
So yes I agree with you that I need to control the entry, hence I am looking the exact list of countries used to set i up as a drop down list so users when entering data will not be able to enter something else.
- Pragati11
Hi Fabiann ,
Have you set any data category under Modelling tab for your Country column in data or is it just a text?
If not then try doing this to your country column and then re-produce the map visual and check.
Also I found these following links useful:
https://radacad.com/power-bi-filled-map-the-good-the-bad-and-the-ugly
https://community.powerbi.com/t5/Desktop/power-bi-map-3-letter-country-code/td-p/171395
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
- Fabiann
Thank 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.