Forum Discussion

ozmike's avatar
ozmike
Resolver I
9 years ago
Solved

Full addresses not plotting on map

Hi 

 

I'm trying to plot a address on a map eg

 

5 Haslam Ct , CARINDALE, Queensland, Australia

 

bing maps finds this , I have categorized the address to column to Address..

 

Any ideas why this can't show on a map..

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi ozmike,

    I add the CARINDALE, Queensland, Australia in table, category it as place, create a Filled Map, it shows correctly. Please review the following screenshot.



    Could you please share all your resource table to test it?

    Best Regards,
    Angelia

10 Replies

  • kaushikd's avatar
    kaushikd
    Resolver II
    9 years ago

    Hi ozmike

     

    In that case you have to catagorize your data.

    Select the column where you have stored the data then categorize it to address and then select in bing map.

    If possible then go for the ArcGIS map which is more reliable as compared to the bing.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Just putting a minor note out there: The "Filled map" visualization works much better if you have this construction:

     

    Calculated column:

    = postal code&" "&Country

    • ozmike's avatar
      ozmike
      Resolver I
      9 years ago

      Hi

      I tried to categorized the address - fail ( see original post)

      i tried your solution postcode & " " & Country - Fail

      I tried the filled map - fail.

      Didn't try arc gis - as it asked to share data.

       

      no luck

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi ozmike

         

        I've had success before with plotting cities in the "Filled map" visual for Australia by using my method.

         

        Could you send me a picture of your postalcode + country column?

  • jamahan's avatar
    jamahan
    Frequent Visitor
    8 years ago

    PowerBI MAPS may have a bug and will somehow not accept the ADDRESS word in the MAPS Location field.

     

    In the query editor try rename your data column header from *Address* to *Adress*