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...
Just a question have you tried to test the mapping using Bing Maps?
And also making sure that you have got the Address, City, State, Country when using the maps?
I also find that setting it to Category of Address or City often works best.
Have not try Bing Map yet.
I definately have data for WA as it showed up in the Legends as you see below.
How do you set category to Address or City? There is no category 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.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 BI