Forum Discussion

blaw's avatar
blaw
Regular Visitor
9 years ago

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...
GilbertQ's avatar
GilbertQ
Super User
9 years ago
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's avatar
blaw
Regular Visitor
9 years ago

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's avatar
    GilbertQ
    Super User
    9 years ago

    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.

  • blaw's avatar
    blaw
    Regular Visitor
    9 years ago

    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's avatar
    GilbertQ
    Super User
    9 years ago

    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's avatar
    blaw
    Regular Visitor
    9 years ago

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

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    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's avatar
    blaw
    Regular Visitor
    9 years ago

    Hi quavaq,

     

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

     

     

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    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.

  • blaw's avatar
    blaw
    Regular Visitor
    9 years ago

    Hi guavaq,

     

    I have tried with State and Country in the Location in the map, but the Legends I can only include state.

     

    It still has no effect. Where do you specify the country in the map just to make sure I did not miss anything?

     

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi blaw

     

    I think that possibly things might be lost in translation.

     

    What I have suggested is that you create a calculated column within your Power BI Model, that contains both the State and the Country. So this means that there will be a new column in your Power BI Model called "State-Country"

     

    And this calculated column will be a combination of your State column with Australia at the end. 

     

    Once you then have this calculated column "State-Country" then change the data categorization to City or state, it should then show correctly.

  • blaw's avatar
    blaw
    Regular Visitor
    9 years ago

    Hi guavaq,

     

    As I explain before I get my data from SSAS. I cannot create a new calculated column in Power BI.

    Not to mention further about the data categorization as it is disable.

    I can only create state-country in my dimension in SSAS.

    If I specified the state-country as  Georgraphy - 'State' in the data type, whether the map in Power BI recognise it as the state in Australia.

     

    I have arlready tried filter out the country to Australia. 

     

     

  • blaw's avatar
    blaw
    Regular Visitor
    9 years ago

    Thanks guavaq for your replies. I actually learn more about Power BI eventhough this issue is not resolved.

     

    Will log this to Microsoft.

     

  • jess18's avatar
    jess18
    New Member
    8 years ago

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

    Thanks in advance.

  • jess18's avatar
    jess18
    New Member
    8 years ago

    Hi,

     

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

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago

    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's avatar
    cartpc
    New Member
    8 years ago

    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's avatar
    GilbertQ
    Super User
    8 years ago
    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's avatar
    cartpc
    New Member
    8 years ago

    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.