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

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'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?