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
hrics12
Frequent Visitor

A line that shows the route between two cities

Hi,

I'm trying to make a report that will show two cities (one in california, and one in colorado). I want to have a visual that shows the route you would take by vehicle between the two cities and the distance on a map of the United States. I've tried using Route Map and IconMap but neither show the street route. Any ideas? I have the longitude and latitude of the two cities. Any help is welcome!

Thank you!

1 ACCEPTED SOLUTION

Hi, @hrics12 

Found a visual object called Route line that you can refer to using it.

vyaningymsft_0-1709790876455.png

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

4 REPLIES 4
v-yaningy-msft
Community Support
Community Support

Hi, @hrics12 

 

According to your description, you can try to use Azure Map as a visual object, just enter the name of the city and open the Traffic layer settings to view the route.

vyaningymsft_3-1709270735495.png

 

vyaningymsft_2-1709270649884.png

 

vyaningymsft_0-1709270480504.png

vyaningymsft_4-1709270763148.png

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

So I have the two cities on the map. I don't see a way to make a highlighted road route between the two using Azure Map.

Hi, @hrics12 

 

If you want to highlight the route between two cities, you can see the link below and need to make Azure Map work with other features.

vyaningymsft_1-1709546308177.png

Related link: Chris Webb's BI Blog: Displaying Routes On A Map In Power BI (crossjoin.co.uk)

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Hi, @hrics12 

Found a visual object called Route line that you can refer to using it.

vyaningymsft_0-1709790876455.png

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

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!

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.