Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Has anyone had any problems using a filter of countries with the filled map visual? I have a number of countries not found. I have a country slicer and filled map visual, along with other charts.
I have categorised my filter column "Countries" as "Country/Region" in the Desktop, so it should know what it's looking at.
Countries not found (so far) but found on www.bing.com/maps:
Bangladesh
Western Sahara
Morocco
Countries/Regions not found and not found on www.bing.com/maps:
Occupied Palestinian Territories ( or OPT)
Polynesia (but the name is found; the area is not outlined)
Has anyone else had problems with this? Or am I doing something wrong? About 50 other countries work fine. Odd. I get that OPT and Polynesia might not register (for differing reasons) but Bangladesh?
UPDATE: using 3-letter codes (https://countrycode.org/), I have got Bangladesh working. Morocco works but includes Western Sahara. Western Sahara's code (ESH) takes me to Estonia! No codes for OPT and Polynesia as expected (as not recognised countries).
UPDATE: Philippines & Domincan Republic removed from above list due to misspelling.
Has anyone else trodden this path????
Solved! Go to Solution.
Hi @Anonymous,
To create a filled map, the location data should include Bing Map-supported geographic data, such as country/region, state/province, or postal code.
In your resource data, all the values in same hierarchy? When Geographic Structure is Different, it's easy to display wrong locations on filled map. Please review this article for more detials.
Thanks,
Angelia
Ethiopia is missing
Hi @Anonymous,
To create a filled map, the location data should include Bing Map-supported geographic data, such as country/region, state/province, or postal code.
In your resource data, all the values in same hierarchy? When Geographic Structure is Different, it's easy to display wrong locations on filled map. Please review this article for more detials.
Thanks,
Angelia
Thanks Angelia for the link - interesting, and your general points are worth considering - I've accepted as solutiion.
I wasn't actually using geographic structure - just country names, but I might try and resolve some disputed areas in that way. Reza Rad's article (your link) - http://radacad.com/power-bi-filled-map-the-good-the-bad-and-the-ugly - shows that he too has struggled to find solutions (albeit local level in New Zealand).
I have now got Bangladesh working - something in my model I suspect. So the rest are disputed countries/regions.
Similar problem with the ISO 2 code. Since Microsoft has (currently) decided to reserve the 2-letter codes for US states.
The 2-letter code is essential for dense Plott-chart-labels.
...I do hope Microsoft will follow international standard territories: city/regions/continents/etc.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |