add post code to map

[Sean-OReilly]

i have a list of properties with the irish post code (called eircode).

how do i get these to correctly display on map visual in power bi?

[PhilipTreacy · Accepted solution]

Hope @Sean-OReilly

See this PBIX file for examples.

I wasn't sure if you just wanted the Eircode, or the full address on the map, so I created 2 maps. The first only uses the Eircode and some random value that I created

The 2nd map uses full addresses, for example, NEWBRIDGE POST OFFICE, MAIN STREET, NEWBRIDGE, CO. KILDARE, W12 ER27

I hope that's the kind of thing you're looking for.

Best regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking Thumbs Up.

[Sean-OReilly]

@PhilipTreacy Thanks a million and thanks for the Pbix sample file - this is exactly what i was looking for. Where did you get the long/lat value ? is there a lookup table of Eircodes and long/lat that i can download?

[Sean-OReilly]

@PhilipTreacy  also - how did you get globe symbols on your table values ?

[mb0307]

To produce map in Power BI you need Latitude (Lat) and Longitude (Long).  If your existing postcode data has Lat/long then you should be able to use them in the map visual.  Otherwise, you need to find a lookup table (postcode to lat/long). 

 ------------

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 

-------------

[MattAllington]

I don't know about Ireland, but in Australia, you add a column with postcode, country (postcode comma country), eg 2111, Australia.  Add this to the map and set the column metadata to be "place"

[Sean-OReilly]

hi matt

how do i set the column metadata to be place ?