Filled map chart doesn't display all Egypt provinces

[Shereen1260]

I tried to use filled map chart however not all 27 provinces are displayed tried all solutions suggested of column name or applying higher geo level nothing works can someone help pls it is very important to my work and I can't figure out a solution

[#2 · Accepted solution]

@Shereen1260 Like this? File attached.

[#3]

Yes that worked well in my private PC . However, on my office PC due to security reasons the map can't display with online service.so I work with offline version It shows some but the rest aren't working I don't know why.
However, many thanks

[#4]

@Shereen1260 

By the way, what is offline version of Map Charts?

[#5]

Great work, can you advice how to create such this map from scratch ?

[#6]

@Ahmed_Badawy Start by creating the table as shown in the picture. Note that the first two columns are "Geography" data-typed (from the Data ribbon, Data Types group) and create a "Map Chart". Not much more to it.