Full addresses not plotting on map

[ozmike]

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

[jamahan]

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*

[Anonymous]

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]

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]

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?

[ozmike]

 Hi i've tried varios categorization - address, postcode - this is for sydney, tried filled and plain map viz.

 

[v-huizhn-msft · Accepted solution]

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

[Anonymous]

Is there a way to plot the actual full address(

5 Haslam Ct , CARINDALE, Queensland, Australia

) rather than the city and country you indicated? I have a list of full addresses(123 john place Spring, Texas) i need to plot and filled map is not picking it up even though i categorized the field as place

[ozmike]

Yes super contributor

 v-huizhn-msft

You must categorise as a place ( not address) so '2000 Australia' will work. also the full address will work . The catch is if you categorise the 'address as an address' - dosen't work (makes sense?), but as a place - even if it is an address will work. so why is an address a place but not an address? but thanks..anyway..

[Anonymous]

@ozmike

At this point it's probably best to share atleast your location data.

[kaushikd]

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.