Map Lines

Greg_Deckler — Fri, 18 Jul 2025 17:48:55 GMT

Came out of this conversation: Create Origin To Destination Map In BI Desktop - Microsoft Fabric Community. Here's a way to create origin to destination lines on a map given a table of cities.

CityLatitudeLongitude

Columbus, OH	39.9611111	-82.9988889
London, UK	51.5	-0.116667
Kansas City	39.099912	-94.581213
St. Louis	38.627089	-90.200203

From and To = VAR __NumSteps = 100 VAR __Steps = SELECTCOLUMNS( GENERATESERIES( 1, __NumSteps, 1 ), "Step", [Value] ) VAR __BaseTable = FILTER( GENERATE( SELECTCOLUMNS( 'Cities', "From City", [City], "From Long", [Longitude], "From Lat", [Latitude] ), SELECTCOLUMNS( 'Cities', "To City", [City], "To Long", [Longitude], "To Lat", [Latitude] ) ), [From City] <> [To City] ) VAR __String = CONCATENATEX( __BaseTable, [From City] & "^" & [From Long] & "^" & [From Lat] & "^" & [To City] & "^" & [To Long] & "^" & [To Lat], "|" ) VAR __Count = COUNTROWS( __BaseTable ) VAR __Table = ADDCOLUMNS( GENERATESERIES( 1, __Count ), "__Data", SUBSTITUTE( PATHITEM( __String, [Value] ), "^", "|" ) ) VAR __Result = FILTER( SELECTCOLUMNS( ADDCOLUMNS( GENERATE( __Table, __Steps ), "Latitude", PATHITEM( [__Data], 3 ) + ( [Step] / __NumSteps ) * ( PATHITEM( [__Data], 6 ) - PATHITEM( [__Data], 3 ) ), "Longitude", PATHITEM( [__Data], 2 ) + ( [Step] / __NumSteps) * ( PATHITEM( [__Data], 5 ) - PATHITEM( [__Data], 2 ) ) ), "Latitude", [Latitude], "Longitude", [Longitude], "From", PATHITEM( [__Data], 1 ), "To", PATHITEM( [__Data], 4 ) ), [From] <> [To] ) RETURN __Result

eyJrIjoiMDZkNjhlMmItZTg1ZC00ZmM2LTkwZTEtNDJiZDA3ZGFlNDRjIiwidCI6Ijg3NDlmOWI5LWYzMmQtNDdhMS1hMjI0LTM2OTQxOGFlMmY1MSJ9

Re: Map Lines

IoTGirl — Tue, 21 Oct 2025 18:48:01 GMT

Awesome! Great sample using the Azure Maps Visual in Power BI! For anyone that wants to try, check out Get started with Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn

topic Map Lines in Quick Measures Gallery

Map Lines

Re: Map Lines