Master The Art Of Mapping In Power Bi: How to easily create Line Maps!

[@HachiAdachi]

Thanks, Ruth! I didn't know that the Icon Map can do that! 🤯 I wonder what else it can do?? 🤔

[@CurbalEN]

Almost everything you wish for free. Is is truly amazing :)

[@barttrudeau9237]

Icon map is amazing and the developer is incredibly generous offering so much functionality for free. Another great tool that is great for visualizations with line work is Synoptic Panel. I would not use it for geography but it's great for things like floor plans and diagrams. It is not been updated in a long time but Marco Russo recently published they are working on a major update. Very cool map visualization Ruth!

[@CurbalEN]

@barttrudeau9237 agree!

[@gunruna20]

This is awesome! I would love if you can look into how to identify the start and stop points. Let say we're tracking vehicles. Hard to tell where the start and stop points are.

[@CurbalEN]

That would depend on how the data looks like!

[@gunruna20]

I'm going to experiment with a GEOMETRYCOLLECTION. I have vehicle GPS data. I did a group by on the vehicle_id and the date, then created the WKT column using LINESTRING. The route displays perfectly and I can move day by day using the play axis visual. I just need to visualize the start and stop points. Thinking maybe this can be done inside a GEOMETRYCOLLECTION with a combination of POINT() and LINESTRING() with conditional formatting.

[@abhijeetghosh27]

This is one of the amazing goodies you offer on your channel. Thank you @Ruth 😀👌👌❤❤❤🎉 Also, Kudos to @James Dales for creating this visual. 👏👏❤😊

[@CurbalEN]

😃😃

[@CarlosGuevara-v1n]

Hello, i have a question The lines doesnt show up in the map. Why is this happening ? I will give you a little context. When i do the transformations in power query, the new column created with the coordinates vector doesnt show up, it shows a duplicate column from the route (in my case is the route name) Can you help me, please?

[@astatine0085]

Great stuff, thanks!

[@vishaljuneja3880]

This is really great and very clear information But what if I do not have Route ID I just have Network, CreatedAt, Latitude and Longitude By applying group by on either time or network - my location of linestring showing at wrong place And I need to know how we can show proper route on roads following This would be really helpful

[@profemavex]

Fácil, solo usa "Índice".

[@Roger_Williams23]

Hola, He visto tu presentación unas cuántas veces. Muchas gracias por este vídeo. Será que es posible darle color a las líneas por id o nombre usando iconmap?

[@CurbalEN]

Pues no se si es posible :(

[@DanielWeikert]

where is the csv? thx

[@bardock2525]

Do you think this can finally be Power BI's answer to the Polygon functionality in Tableau that allows one to create any shapes as long as they can plot out the coordinates for it? Or is this just lines and not really an ability to combine groups of lines and color the area between them - which is what Tableau allows you to do. Tableau takes the last point in a group, connects it back to the first one in the group and calls that a Polygon and fills it with color. A simple but super duper powerful tool that allows you to pretty much create any crazy viz in Tableau.

[@CurbalEN]

You can do polygons in icon map but i am not sure if the viz can do what you mention here. Give it a go!

[@m.rosariomartinezmiguelez9015]

Me ha gustado mucho verte .❤

[@CurbalEN]

Os llamo mañana ❤️

[@jay6817]

Worked a Treat. Not bad for situations when users don't have ArcGIS accounts to view

[@CurbalEN]

Yes! Icon maps are great :)

[@techierahul281]

This can be done through scatter plots as well

[@CurbalEN]

Even better!

[@luizacorrea8510]

God , you're awsome❤❤❤❤❤❤❤❤

[@CurbalEN]

❤️

[@krishraj4]

As this is not a certified visual, not sure many organizations will be able to use it or not.

[@CurbalEN]

I can not be certified as it will always send data back to the mapping services. All map visuals do it, in including the native ones.