Forum Discussion
add post code to map
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?
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.
6 Replies
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.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?
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"
hi matt
how do i set the column metadata to be place ?
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
-------------
