cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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
Highlighted
Microsoft
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
Highlighted
Resolver II
Resolver II

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

Highlighted
Anonymous
Not applicable

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

Highlighted
Resolver I
Resolver I

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

Highlighted
Anonymous
Not applicable

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?

Highlighted
Resolver I
Resolver I

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

 

 

 

Highlighted
Microsoft
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

Highlighted
Anonymous
Not applicable

Re: Full addresses not plotting on map

@ozmike

 

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

Highlighted
Resolver I
Resolver I

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

Highlighted
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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors