Heatmap by UK postcode area

[RDF25087]

Hi all -

Re-posting because I can't see my original query....

I have some basic data around UK post codes and a count:

Post Code Area	Count
HR	105
CV	462
B	1388
GL	200
WR	256

All I need is a heat map showing the density of the count in each post code area.

Any help would be greatly appreciated.

RDF

[Anonymous]

Hi @RDF25087 ,

Geocoding Postcode Areas: Since Power BI does not natively recognize UK postcode areas as geographical locations, you'll need to enrich your data with geographical coordinates (latitude and longitude) for each postcode area. This can be achieved by using external geocoding services or datasets that provide a mapping between postcode areas and geographical coordinates.

Creating the Heatmap:

• Import your enriched dataset into Power BI.
• In Power BI Desktop, select the Map visual from the Visualizations pane.
• Add the latitude and longitude fields to the Location field well. If you've managed to map postcode areas to a recognizable geographical hierarchy instead, use the postcode area field here.
• Drag the count field to the Size field well to represent the density.

Best Regards,

Xianda Tang

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