Forum Discussion
How to Map Multiple GEO Codes Address on One Map
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?
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-with-Winners/ba-p/890814
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
2 Replies
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-with-Winners/ba-p/890814
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