Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |