@@HowtoPowerBI single day this works fine, but in real data we have multiple dates and months and years , so it will show all the previous ones right? how to show only that days deliveries and exclude previous days deliveries
@amreensk3039 you need a dim date and a dim time table. The resort can then be filtered to the desired date like you would in any other report. That's why the date and time columns are split out in the fact table.
Cool function! I am thinking that this could also illustrate and highlight the path a product takes in a factory with layout maps and show if a production line is stalling in amy step in the process.
This is really slick. What I would love to see is some recommendations on how to prep address data into latitude and longitude data to better utilize the map visual. Very common for address data to be pulled in or scrapped in datasets I see, but the conversion in DAX can be tricky for those without experience. Maybe you could demo writing some Dax or powerquery to use the googlemaps api in the transformation panel to translate addresses into latitude and longitude coordinates?
Already have a video on that :) How to use the Google Geocoding API in Power BI | Quickly find Longitude and Latitude Coordinates th-cam.com/video/xBF_ZaGW87k/w-d-xo.html
Hi Bas, looks amazing and really easy to implement. For example, if you drive from Amsterdam tot Paris and retour to Amsterdam within the same route will it be possible to have different colors to highlight your route?
Hi Bas, i have go through you how to build financial report video..i have question if i want to add the Web URL in my table how to add...please respond
Excellent video, as always. I really love your videos because the way how you explain different topics is not boring and it's very clear and understandable. In this specific topic, I think the key is the Dim_Time table and obviously to have a Fact table with the right data points for Latitude and Longitude.
@HowtoPowerBI - different options to show the power bi desktop report in power pages portal like embedded link or s - handle authentication (sync portal authentication with row level security from power bi desktop) -best way to show visuals whether as a report embedded or power bi dashboard in power pages -if I am having multiple pages in power bi desktop, to show these multiple pages using proper navigation in power pages after embedding the link in power pages rather than showing as tabs that you see in power bi desktop -canvas size settings when embedding report. Should we handle page format in desktop only or in power pages Thank you very much in advance.
Hi Bas, thanks a lot, very interesting: Maybe you can make a video how to get the Longtitude and Lattidude from given addresses? Maybe with Google API?
Already have one :) How to use the Google Geocoding API in Power BI | Quickly find Longitude and Latitude Coordinates th-cam.com/video/xBF_ZaGW87k/w-d-xo.html
A awesome one! I am into construction project management. We have linear projects like laying of pipeline, or cable or rail. Can I use this to visualise the projects as they progress through various kilometre points? We will be monitoring distance covered at the date of reporting
cool video, everything is amazing, but......... custom visual is acting like a bottleneck if I wanted to implement this amazing functionality to clients reports, they would straighaway reject the use of custom visuals, any alternate methods using non custom visuals @Bas?
azure map is native .. however the play axis visual not .. instead of that you could go for a "normal" slicer (maybe with a slider) where you can pick the time
Thanks
Cool man!
My jobs are using Power BI and finally I can make delivery tracking on Power Bi Map Visualization.
nice! 😎👊
@@HowtoPowerBI single day this works fine, but in real data we have multiple dates and months and years , so it will show all the previous ones right? how to show only that days deliveries and exclude previous days deliveries
@amreensk3039 you need a dim date and a dim time table. The resort can then be filtered to the desired date like you would in any other report.
That's why the date and time columns are split out in the fact table.
Just add a date slicer?
Great! I was looking for it for last 5 years
Great man. I am a big fan of your videos. The way you explain them is uniquie
Thanks!
Perfectly explained and demonstraited
Hi and Thanks. Does it need internet to run Asure map? What is your substitude for Asure map that does not need internet?
yes it needs internet, you can use a shape map or Synoptic Panel(custom visual) as a workaround
Cool function!
I am thinking that this could also illustrate and highlight the path a product takes in a factory with layout maps and show if a production line is stalling in amy step in the process.
i think so, you could make use of the reference layer to get the factory layout and show that on a blank map
This is so cool. Thank you for this vid!
Glad you liked it!
straight into my Logistics dashboard, thank you for sharing BAS
Nice 💪
Instead of using time in PointOrder, is it possible to use the order of visiting points per pathID?
Amazing, when I do it, in the animation the lines just show up at the end, what am I doing wrong?
This is really slick. What I would love to see is some recommendations on how to prep address data into latitude and longitude data to better utilize the map visual. Very common for address data to be pulled in or scrapped in datasets I see, but the conversion in DAX can be tricky for those without experience. Maybe you could demo writing some Dax or powerquery to use the googlemaps api in the transformation panel to translate addresses into latitude and longitude coordinates?
Already have a video on that :) How to use the Google Geocoding API in Power BI | Quickly find Longitude and Latitude Coordinates
th-cam.com/video/xBF_ZaGW87k/w-d-xo.html
What camera are you using to record yourself?
Absolutely brilliant ! Thanks !
Hi Bas, looks amazing and really easy to implement. For example, if you drive from Amsterdam tot Paris and retour to Amsterdam within the same route will it be possible to have different colors to highlight your route?
How to make a conditional format on the lines?
Bas, this is amazing! Question: it looks like your mapping time for a single day. How to do this across days? Say for a month?
Hi Bas, i have go through you how to build financial report video..i have question if i want to add the Web URL in my table how to add...please respond
Can this be done on a custom map? Not world map?
you can add a reference layer (learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-add-reference-layer?tabs=upload)
can you please give me the dataset you use to make this visual? it would help ma a lot.👃
Download link is in the description
Hi! You can replace if statement with function int()
Hi, Path Layer option is greyed out for me, what might be the reason?
You might have activated some other layers .. so far only works with bubble and line layer
Excellent video, as always. I really love your videos because the way how you explain different topics is not boring and it's very clear and understandable. In this specific topic, I think the key is the Dim_Time table and obviously to have a Fact table with the right data points for Latitude and Longitude.
that s so nice to hear, thanks a lot!!!
Did you create the Path ID? If so, was that done in the source data, or could that be added in Power Query or a calculated column?
Yes, can be done in all 3.. probably power query is the most practical for most cases
@HowtoPowerBI does the path ID have to be an integer?
Worth the couple of days wait! 👏
😄☺️thanks
Wow .. thanks a lot Bas, this is exactly what I look for.
💪🚀🚀🚀
excelente Aporte gracias , saludos desde Colombia
gracias!!! , saludos desde Germany 😁
so cool where can I find dataset like this one for other projects? You are Legend Bas!
thank you 💻😎 !! The file with for this video you can download here -> datatraining.io/powerbi-how-to
Thanks, Paul
Thanks 😊!!!
I wonder if your technique for animating the delivery routes could be used to animate an SVG image 🤔. Great video, very nicely done
thank you! .. yes also works with svg
Is it possible for this new map to create an optimized route?
No
no not really possible
@@HowtoPowerBI thanks for your answer...any way to do that? in power BI?
@@jpfm79 maybe some of the google map custom visual let you do that ... I haven't tried
Can you please do a video on embedding reports to a power pages portal. A complete flow in power pages side and also power bi end😊
what specifically would you be interested in when it comes to embedding?
@HowtoPowerBI
- different options to show the power bi desktop report in power pages portal like embedded link or s
- handle authentication (sync portal authentication with row level security from power bi desktop)
-best way to show visuals whether as a report embedded or power bi dashboard in power pages
-if I am having multiple pages in power bi desktop, to show these multiple pages using proper navigation in power pages after embedding the link in power pages rather than showing as tabs that you see in power bi desktop
-canvas size settings when embedding report. Should we handle page format in desktop only or in power pages
Thank you very much in advance.
Hi Bas, thanks a lot, very interesting: Maybe you can make a video how to get the Longtitude and Lattidude from given addresses? Maybe with Google API?
Already have one :) How to use the Google Geocoding API in Power BI | Quickly find Longitude and Latitude Coordinates
th-cam.com/video/xBF_ZaGW87k/w-d-xo.html
A awesome one!
I am into construction project management. We have linear projects like laying of pipeline, or cable or rail.
Can I use this to visualise the projects as they progress through various kilometre points?
We will be monitoring distance covered at the date of reporting
yes you can 💪
@@HowtoPowerBI how do i set up to monitor planned vs actual progress?
@@shimonkephaonwuneme9663 you could use pathID for that. One pathID being planned and the other actual progress.
I'd assume a dataset with planned points with longitude and latitude with projected dates Vs actual?
@@stevencook6541yes sure
looks like a great idea. Sadly, Azure Maps are blocked by my org
Amazing
thank you!!! 😎
Fantastica.
thanks !!
Nice
😁 thanks!
👏👏👏
😁💻 thx
cool video, everything is amazing, but......... custom visual is acting like a bottleneck if I wanted to implement this amazing functionality to clients reports, they would straighaway reject the use of custom visuals, any alternate methods using non custom visuals @Bas?
azure map is native .. however the play axis visual not .. instead of that you could go for a "normal" slicer (maybe with a slider) where you can pick the time