Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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"
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"
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).