Forum Discussion
RDF25087
2 years agoHelper I
Heatmap by UK postcode area
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 ...
Anonymous
2 years agoNot applicable
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.