Australia map not working correctly

[blaw]

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. Western Australia (WA) and New Zealand (NZ)  did not show.

Did anyone have this issue?

[Anonymous]

@blaw,

Yes, I've found the standard Map visual to be a little quirky.  If I map 18,184 x  BOM rainfall weather stations on Lat and Lon, I get this - nothing north of the Canberra line...   If I export the data, I get 17, 802 rows.

If I add the Name as a Location on the Map, it shows dots everywhere but, if I export the data, I get 17, 493 rows.

Some of the differences are likely due to data - e.g. overlapping/obsolete weather stations at the same location.

For your map, and assuming your data is complete per @GilbertQ, do you see WA stores if you filter on some other criteria? 

What do you get if you export the data from the visual?

[GilbertQ]

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.

[blaw]

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.

[GilbertQ]

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.

[blaw]

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.

[GilbertQ]

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

[blaw]

Hi 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.

[GilbertQ]

Hi @blaw, is it possible to send a sample of data in CSV format so that I can test it from my side?

Not sure what exactly is going on without viewing the data.

[jess18]

Hi,

Just wondering whether this issue has ever been resolved please. I am experiencing similar issue. Thanks in advance.

[GilbertQ]

Hi there, I would ensure that you have got the column with the correct data which will be Address, State, Post Code, Country

And then ensure that the Data Category is set to Address.

[cartpc]

Hi,

We are having the same issue- however it is very intermittent. We have reproduce the issue using a column of Australian States using concatenated strings (DataCategory = StateOrProvince) where an example of the column contents looks like ‘Western Australia, Australia’, and as a Hierarchy Structure with a ‘Country’ column (DataCategory = Country) and ‘StateName’ column (Data Category = StateOrProvince). We have not been able to fix the problem and so have moved to using a different visual- SynopticPanel, in our production environment. However if there is a known fix for the problem Bing Map issue, that would be great to know.

BTW, when you use DataCategory = Address, is this just a suggestion? Or are you suggesting to use this instead of StateOrProvince.

[GilbertQ]

Hi there, in the past I would try different data categories, and a slightly different combination for the Country and State?

I personally have not had any issues with the standard maps in Power BI. I am not sure how the synoptic chart would make it any easier.

Do you perhaps have some sample data or sample PBIX file to have a look at?

[cartpc]

I'm not sure how to send a pbix file through this application, but here is a snippet of event that happen about 2 months ago. You can see the data associated with the map. The annotataion is attached to the tooltip.

For reasons unknown, Bing just didn't render South Australia, NSW or Victoria.  Overtime (a few days) it just 'fixed' itself.

Synoptic Panel by OKViz - https://okviz.com/synoptic-panel/.  Works well, though does require some setup, but doesn't have the issues we currently have with Bing. 

[jess18]

Hi, just wondering whether this issue has ever been resolved please. I am experiencing similar issue.

Thanks in advance.

[blaw]

Just found out what was the issue.  WA - Western Australia is interpreted as Wachington State  in US.

So all the time it is pointing there in US instead of Australia.

Any idea on how I get around this?

[GilbertQ]

Hi @blaw, as I mentioned before if you could create another column that does not ONLY contain the State name, but also includes the Country name.

EG: Country-State = WA,Australia

[blaw]

Thanks quavaq.  Just wandering how can the map recognise  the State-Country?

[GilbertQ]

Hi @blaw

Do you mean how to create the calculated column?

If so you can just create a new Calculated Column in your SSAS Model with State-Country = [State] & ",Australia"

[blaw]

Hi quavaq,

No. What I meant was whether the Power BI map can recognise State-Country instead of State.

[GilbertQ]

hi @blaw

Ok I have found that you have to specify the country, otherwise it always assumes it is from the USA when there is something with the same name.