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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
650AA
Helper I
Helper I

Heat Map

Hi I am looking for some advice and guidance as how to display some rail data in a map in power bi for the rail regions in the UK  which are the following Eastern, North West & Central, Scotland's Railway, Southern and Wales & Western.

However Eastern is being shown in Europe, North West & Central in USA, etc 

How would I display the data similair to the link below

Thank you all in advance.

NR regions rail map v27Rg.pdf (projectmapping.co.uk)

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @650AA ,

Please try below steps:

1. Data Preparation:
- Ensure that your dataset includes a column with the correct geographical names or codes for the UK rail regions.
- If possible, include additional geographical data such as latitude and longitude coordinates for more accurate placement.

 

2. Choosing the Right Map Visualization:
- Power BI offers different types of map visualizations such as the standard Map, Filled Map, and Shape Map. For a heat map, you might want to use the Filled Map.
- If the built-in map visualizations do not meet your needs, consider using custom visuals from the Power BI Visuals Marketplace, such as the Synoptic Panel by OKViz.

 

3. Setting Up the Map Visualization:
- Drag the map visualization onto your report canvas.
- Add the geographical column to the Location field well.
- Add the measure or value you want to represent (e.g., passenger numbers, frequency of service) to the Color saturation field well to create the heat effect.

 

4. Adjusting Map Settings:
- In the Format pane, adjust the map settings to fine-tune the appearance of your heat map.
- Make sure the Data Category for your geographical column is set correctly under the Modeling tab to ensure Power BI interprets the data as UK regions.

 

5. Troubleshooting Incorrect Locations:
- If regions are still showing up incorrectly, you may need to refine your geographical data or use a different naming convention that Power BI recognizes.
- Consider creating a custom map with the Shape Map visual if the built-in geocoding does not recognize your regions accurately.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @650AA ,

Please try below steps:

1. Data Preparation:
- Ensure that your dataset includes a column with the correct geographical names or codes for the UK rail regions.
- If possible, include additional geographical data such as latitude and longitude coordinates for more accurate placement.

 

2. Choosing the Right Map Visualization:
- Power BI offers different types of map visualizations such as the standard Map, Filled Map, and Shape Map. For a heat map, you might want to use the Filled Map.
- If the built-in map visualizations do not meet your needs, consider using custom visuals from the Power BI Visuals Marketplace, such as the Synoptic Panel by OKViz.

 

3. Setting Up the Map Visualization:
- Drag the map visualization onto your report canvas.
- Add the geographical column to the Location field well.
- Add the measure or value you want to represent (e.g., passenger numbers, frequency of service) to the Color saturation field well to create the heat effect.

 

4. Adjusting Map Settings:
- In the Format pane, adjust the map settings to fine-tune the appearance of your heat map.
- Make sure the Data Category for your geographical column is set correctly under the Modeling tab to ensure Power BI interprets the data as UK regions.

 

5. Troubleshooting Incorrect Locations:
- If regions are still showing up incorrectly, you may need to refine your geographical data or use a different naming convention that Power BI recognizes.
- Consider creating a custom map with the Shape Map visual if the built-in geocoding does not recognize your regions accurately.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your help, I can implement your advice and guiudance. Out of interest would anyone have a table with the data for network rail regions? thanks

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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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