Western Australia not appearing on filled map

[Anonymous]

I've been having difficulty getting Western Australia to show up on the filled map.  There is a sizable amount of data for this state in my dataset.  The other states show up fine, however WA is the only state in my dataset where the state code is 2 characters instead of 3.  Has anyone else had a similar problem?

 

[GilbertQ · Accepted solution]

Hi @Anonymous

It is due to the fact that if you only have got "WA" there it decodes this to Washington State in the USA

Whilst if I changed the names to the Full State Names: EG: From "WA" to "Western Australia" I then get it working as expected. So I would suggest replacing the names with a conditional column to the full state name and then ensuring that the Data Category is set to "State or Province"

[Anonymous]

Arg, you are right.  Why didn't I think of that?  I thought that was fixed with the Location Heirarchy (which i have set up).

[GilbertQ]

All good mate, at least is was an easy fix for a Friday afternoon 🙂