cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ozmike Member
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-huizhn-msft
Microsoft

Re: Full addresses not plotting on map

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.

1.PNG2.PNG

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

Best Regards,
Angelia

View solution in original post

9 REPLIES 9
kaushikd Member
Member

Re: Full addresses not plotting on map

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.

 

Capture.PNG

ValubiMartin Senior Member
Senior Member

Re: Full addresses not plotting on map

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

Re: Full addresses not plotting on map

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

ValubiMartin Senior Member
Senior Member

Re: Full addresses not plotting on map

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

Re: Full addresses not plotting on map

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

 

 Capture.PNG

 

 

 

Microsoft v-huizhn-msft
Microsoft

Re: Full addresses not plotting on map

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.

1.PNG2.PNG

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

Best Regards,
Angelia

View solution in original post

ValubiMartin Senior Member
Senior Member

Re: Full addresses not plotting on map

@ozmike

 

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

ozmike Member
Member

Re: Full addresses not plotting on map


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

jamahan Frequent Visitor
Frequent Visitor

Re: Full addresses not plotting on map

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*

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors