SOLVED

Excel Map Not Showing all Provinces for Saudi Arabia

%3CLINGO-SUB%20id%3D%22lingo-sub-1393105%22%20slang%3D%22en-US%22%3EExcel%20Map%20Not%20Showing%20all%20Provinces%20for%20Saudi%20Arabia%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393105%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20mapping%20some%20basic%20data%20at%20regional%20level%20for%20Saudi%20Arabia.%20Country%20has%2013%20regions%20and%20event%20though%20excel%20identifies%20correctly%20each%20one%20of%20the%20regions%20in%20the%20Geographic%20Data%20format%20it%20fails%20to%20display%20data%20on%20the%20map%20for%20two%20regions%20namely%3A%20Al_Qassim%20and%20Ha'il%20Regions.%3C%2FP%3E%3CP%3EI%20saw%20some%20earlier%20pots%20on%20similar%20problems%20for%20Germany%20or%20Spain%2C%20and%20tried%20various%20alternatives%20but%20was%20not%20able%20to%20solve%20the%20problem.%3C%2FP%3E%3CP%3Eany%20suggestion%20would%20be%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1393105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1393578%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Map%20Not%20Showing%20all%20Provinces%20for%20Saudi%20Arabia%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1393578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669189%22%20target%3D%22_blank%22%3E%40kce_powerten%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20works%20if%20remove%20geography%20data%20types%2C%20play%20with%20column%20names%20and%20country%2Fprovince%20names%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192102i6170B49F919730A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EArtificial%20intelligence%20is%20not%20very%20straightforward%20thing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397497%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Map%20Not%20Showing%20all%20Provinces%20for%20Saudi%20Arabia%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397497%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20quite%20interesting%20that%20removing%20Geography%20Data%20type%20makes%20such%20a%20difference!%3C%2FP%3E%3CP%3EThank%20you%20once%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397516%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Map%20Not%20Showing%20all%20Provinces%20for%20Saudi%20Arabia%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669189%22%20target%3D%22_blank%22%3E%40kce_powerten%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome.%20In%20Map%20Charts%20everything%20could%20make%20a%20big%20difference%2C%20never%20know...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1504110%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Map%20Not%20Showing%20all%20Provinces%20for%20Saudi%20Arabia%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504110%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F669189%22%20target%3D%22_blank%22%3E%40kce_powerten%3C%2FA%3E%26nbsp%3Bcan%20you%20please%20explain%20how%20did%20you%20create%20this%20type%20of%20excel.%20i%20am%20not%20sure%20to%20understand%20it.%20is%20it%20power%20query%3F%20how%20did%20you%20link%20the%20data%20to%20bing.com%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3Egive%20me%20hints%20to%20google%20it%20or%20youtube%20it%20plz.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have tried mapping some basic data at regional level for Saudi Arabia. Country has 13 regions and event though excel identifies correctly each one of the regions in the Geographic Data format it fails to display data on the map for two regions namely: Al_Qassim and Ha'il Regions.

I saw some earlier pots on similar problems for Germany or Spain, and tried various alternatives but was not able to solve the problem.

any suggestion would be appreciated

7 Replies
best response confirmed by kce_powerten (New Contributor)
Solution

@kce_powerten 

It works if remove geography data types, play with column names and country/province names

image.png

Artificial intelligence is not very straightforward thing.

@Sergei BaklanThank you,

 

It is quite interesting that removing Geography Data type makes such a difference!

Thank you once again!

@kce_powerten , you are welcome. In Map Charts everything could make a big difference, never know...

@kce_powerten can you please explain how did you create this type of excel. i am not sure to understand it. is it power query? how did you link the data to bing.com ? 

give me hints to google it or youtube it plz. 

@Sergei Baklan - Here attached is my problem file - can you help me to correct it please?

 

Regards

 

Andrew

Same problem for egypt provinces can you help