Chart Maps Missing Country

Question

Hi,&nbsp;Has anyone experienced and have a solution for a country not showing in the Chart render?&nbsp;In my specific case mainland Spain is missing. The Balearic islands are showing, meaning that it does recognize the Country Data Type 'Spain' as a valid entry, yet...&nbsp;Thanks for your suggestions and help.

sergeibaklan · Answer

ANBOXLB&nbsp;
Spain is recognizable

What's wrong in your concrete case it's hard to say based on part of screenshot without seeing a file. Map charts is quite sensitive to column names, works better with tables rather than ranges, doesn't like if you have different structuring levels in one column (e.g. country and controlled territory) - try to play in this direction.

pwbrundage · Answer

SergeiBaklan&nbsp;I, too, am having a problem displaying Spain. &nbsp;I've attached my spreadsheet to show you the challenge. &nbsp;

sergeibaklan · Answer

pwbrundage&nbsp;
It recognizes it, but only partly, see this small dot

Perhaps the other part is considered as Spain County in South Dakota since you are working with world map.
If help to Excel and name columns as
&nbsp;
&nbsp;
saying we are working with countries, more of Kingdom of Spain will appear

Please check in attached file.

anboxlb · Answer

SergeiBaklan&nbsp;thank you for your responses. Indeed the map does respond to the name and highlighting the Balearic as well as Tenerife and other islands in the Atlantic, but it refuses to show the mainland.&nbsp;I do have headers,tried with and without geography data typetried with and without table formattingtried with just Spaintried different naming and languages&nbsp;Eventually gave up and moved the data to PowerBI.&nbsp;

sergeibaklan · Answer

ANBOXLB&nbsp;
I see, but that's hard to discuss without the file. Map Charts is quite specific and sensitive to details, sometimes it's enough to change the order of records. Sometimes nothing helps, but quite seldom.

Forum Discussion

Chart Maps Missing Country

6 Replies

Resources