Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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)
Solved! Go to Solution.
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
147 | |
85 | |
66 | |
52 | |
46 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |