How to Map Multiple GEO Codes Address on One Map

[Anonymous]

I have a single Excel file with multiple GEO Codes representing a home buyer when they were a prospect, and later after they became a buyer.   Basically, the old address and new address.   I want to show the prospect home address in one color and show their new home address in another (blue).    How can I do this when PowerBI only allows for one Latitude and one Longitude?

[amitchandak · Accepted solution]

Power BI map allows you to at Log lat. Also, you can add a field in the legend(field having New/old in your case) that will color up.

Refer the use of legend: https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[Adamtall]

Hi,

You can define a new column and use it as legend.

example.

Old adress = 1 and New address = 2, and in the visual you define 1 as green and 2 as blue.

Hope this can help you 🙂