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
RDF25087
Helper I
Helper I

Create layered UK map

Hi all -

 

I've been tasked with creating a layered map of our sales force and where they are spending their time.

 

So, in the first instance I need to plot points on a map of the UK where our sales personnel are based. I have the latitude and longitude of their base locations. I can do this no problems.

 

However, secondly, I then need to overlay that map with a heat map showing in which post code areas that sales person has spent their time.

 

An example of this data would be something like this:

DateSalespersonBase LatitudeBase LongitudeVisit Post Code Area
01/10/2023Bob53.543704-1.098183EX
01/10/2023Bob53.543704-1.098183EX
02/10/2023Bob53.543704-1.098183EX
02/10/2023Bob53.543704-1.098183EX
02/10/2023Bob53.543704-1.098183PL
03/10/2023Bob53.543704-1.098183PL
03/10/2023Bob53.543704-1.098183TQ
05/10/2023Bob53.543704-1.098183TQ
07/10/2023Bob53.543704-1.098183BH
01/10/2023Sarah51.512515-0.586115B
01/10/2023Sarah51.512515-0.586115B
02/10/2023Sarah51.512515-0.586115CV
02/10/2023Sarah51.512515-0.586115CV
02/10/2023Sarah51.512515-0.586115CV
03/10/2023Sarah51.512515-0.586115CV
03/10/2023Sarah51.512515-0.586115DY
05/10/2023Sarah51.512515-0.586115WR
07/10/2023Sarah51.512515-0.586115NG

 

Any help would be greatly appreciated.

 

RDF

2 REPLIES 2
RDF25087
Helper I
Helper I

Thank you @v-xinruzhu-msft for the reply.

 

It's not quite what I am after. I want one layer to simply plot the location of the sales person. The second layer should outline UK poast code areas (e.g. EX, TQ, PL etc...) and this layer should be the heatmap.

 

Thanks

RDF

v-xinruzhu-msft
Community Support
Community Support

Hi @RDF25087 

You can use the custom visual:heat map, and put the related field to the visual

vxinruzhumsft_0-1697439169933.png

 

You can refer to the attachments and the following link.

Heat Map in Power BI |Step by Step Guide to Create Heat Map in Power BI (wallstreetmojo.com)

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.