Map Visual query

[ChrisPBIUser]

After suggestions for an appropriate map visual for my query.

Within a dataset, I have two postcode (zip code) columns, one is a retailer postcode and the other is a customer postcode.  The normal MAP (mircosoft bing) visual within Power BI desktop works find with just one of the postcodes.  For example, if I put in the retailer postcode you will see a bubble on the map for the postcode values and visa versa.  So all good but it doesn't allow for both postcode to be entered, well it does but the second postcode doesn't show.

So what I'm after is a map visual that will allow both postcode columns to be displayed on the MAP in different colours.  The reason is so you can select one particular retailer postcode, say displayed in red, and then you can see the customers for that retailer, displayed in say blue.

Any advise or suggestions will be appreciated.

[PaulDBrown · Accepted solution]

Here is one way...(For this example, these are just random locations - no real data)

Basically you need the Zip codes in a single column (in my example, the lat/long coordinates). If you structure the data as follows

including the "Parent retail" column assigning both the retail outlet and the corrresponding customers to the same retail value, you can then get the following:

I've attached the sample PBIX file

[ChrisPBIUser]

@PaulDBrown absolutely brilliant.  Exactly what I was after.  Just need to tweak the data to bring in Lat / Long and hopefully it'll work a treat.  

[PaulDBrown]

Sorry, perhaps my comment was misleading. I used lat/long coordinates because I copied them from Google maps (it was easier than searching for and making a working list of postcodes). If the postcodes display correctly, you don't need lat/long coordinates. 

[ChrisPBIUser]

Honestly, it fine, as we I need to include Long / Lat to measure the distance between the two

[amitchandak]

@ChrisPBIUser , I doubt you can use both, Also, I do not think it will allow you two measures, Otherwise you can use common tables and two measures. And one measure use userelationship.

Create two measure, Create calcultion group and then use that as legend

Single postcode table, join to both.

Two measures using userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Then

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[ChrisPBIUser]

Cheers for the prompt reply.  I'll take at look to see if it will do what I need, but as you stated at the start it looks like it will not allow two measures on the actual visual.