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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.