cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Countries missing on filled map visual

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???? 

1 ACCEPTED SOLUTION
v-huizhn-msft
Microsoft
Microsoft

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

View solution in original post

3 REPLIES 3
v-huizhn-msft
Microsoft
Microsoft

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

View solution in original post

Anonymous
Not applicable

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.

 

 

Ola
Frequent Visitor

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.

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors