Forum Discussion
Australia map not working correctly
I am using the Map to try to map our company stores (by state ) in the Australia map. The Legends of the states showed with 8 differenct colours. However only 6 states showed up on the map...
Hi there.
When you click on your state column in the ribbon click on the modeling button.
Then in there you will see the data categorization set to Uncategorized. Change this to city.
You should then see a globe next to the state column name. Showing that it is a geographical data category.
When you click on your state column in the ribbon click on the modeling button.
Then in there you will see the data categorization set to Uncategorized. Change this to city.
You should then see a globe next to the state column name. Showing that it is a geographical data category.
Hi guavaq,
Thanks. I followed your instruction but the data category in the modelling is disable as show below.
I am getting my data from Analysis Services. Not sure this got anything to do with this.
- Ahh ok. If you are using SSAS Tabular or Olap with SQL2012 SP2 you can set the data category there. Then that should pull through to Power BI.
Also make sure that your column has got at the very least the state and country.
Eg. Qld, Australia
Ideally I would suggest having Queensland instead of QLD. If you can't do that in SSAS then create a calculated column in Power BIHi Guava,
Thanks for the suggestions.
I tried to change the state to data type of Georgrahic - StateOrProvince in SSAS and also the city, country and Postcode.
These changes have no effect. It just excludes WA - Western Australia.