Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ChrisPBIUser
Helper III
Helper III

Map Visual query

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.

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

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

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

retail11.gifI've attached the sample PBIX file





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

6 REPLIES 6
PaulDBrown
Community Champion
Community Champion

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

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

retail11.gifI've attached the sample PBIX file





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@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.  

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. 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

amitchandak
Super User
Super User

@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

 

 

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.  

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors