Відео

Hi Zeidinho, Thanks for watching. I really love this video. It get's so much views even to this day, and it spurred me on to create a whole playlist about the Gantt chart visuals. ua-cam.com/play/PLBE7Yqq2lkv6-mN1EK2_ry7bai_zpTQ_2.html Regarding your question, this is a premium (paid) feature. From their website and demo file: To better visualize Milestones under all tasks, Gantt Chart offers a Premium feature for showing Milestone shapes on tasks. Drag a date type field into the Milestones* data field to load the a milestone shape for each task. On dragging more date columns, more milestones are plotted on each task. There are separate milestone settings added in formatting pane per milestones (Maximum 5 fields allowed in Milestones). Users can customize milestone shape and color. When you hover over a milestone shape, you can see the milestone name and formatted date. This (first) plan unlocks below additional features Progress Bar: Show progress bar on tasks based on a measure value Task Status: Show custom colored task status flags based on a categorical field Task Milestones: Plot date fields as milestones on task bar with custom colored shapes Row Configuration: Customize the row height and task bar radius

@@TheProjectCorner thanks a million. I'll get the premium version and try this. In my excel, do I have to have milestone dates in a separate column, and will it be labelled on the chart? I was hoping I could have all the key tasks (i.e category) in one column, and in a separate column I could have a drop down to confirm if it's a milestone or not, and for the date,I could enter the same date in Start and Finish, but I'm not sure the MAQ Gantt will be able to interpret this. The reason I'm asking is because I'm dealing with many different stakeholders including from business and there's simply no PM tool (I have a few known ones at my disposal) that can generate the report I need so I thought I'd do everything on excel and then produce a powerBI report to show status of project. I'll check the other videos you shared in the link, maybe the answer is there

Hi NKordestani, thanks for the comment. The phase start and end dates drive the milestones of the schedule. If a date is different from a previous reporting moment (date) it will effect the line of that milestone. It might go up or down. If the date didn't change the line will be straight. Hope that makes sense

Hi Spimoin, thanks for the comment. I agree for some part at least. It sometimes feels like we are all beta testers. Let's hope the beyond (preview) version works.

Absolutely 😞 I agree. Did you see the BI visuals graveyeard?

In case you know a developer, these two pages might be interesting to have, it contains the source code for the timeline storyteller visual. And maybe you could even grab the visual from it. github.com/Microsoft/PowerBI-visuals-TimelineStoryteller github.com/microsoft/timelinestoryteller

You could also use the file I created earlier. It contains the timeline storyteller visual and is available from my subscribers onedrive

And, last comment, sorry for spamming you, but I got excited: ua-cam.com/video/mqDDgPDhSE4/v-deo.html

Not without an additional layer on top and some customization.

The party is still going so don't worry 😉

Hi Piyushsingh, that's true. I'm using a measure on that timeslot. Here's the formula from the DAX: Duration = CALCULATE ( SUM ( msdyn_project[msdyn_duration] ) ) Hope this clears up the section. Thanks for your comment.

And thank you for being a viewer

It's been a while for me, but you might be able to do so by creating a time hierarchy with YY/QQ and use that.

Looking into it on the visual itself, it doesn't seem to have that option.

@@TheProjectCorner thank you for trying and testing!

Hi James, yes, using the url of the plan and adding it in a Loop component. I might do a follow up vodeo and include this trick in there.

@@TheProjectCorner But is there no way to make it a Loop component? One of the attractive things about Loop is being able to share the components all over the place, e.g., in Teams chats, etc.

Hi guys, I think it's a great topic to follow up. I'm on vacation now and have another video scheduled ( I need to finish the audio and editing), but after that, I'll jump on the topic.

Damn that Dutch accent 😉. Thanks for the tip, I'll try and remember it for the next video.

Hi Rodrigue, I will double check the files tomorrow and see if it's not available from the share. You should have received a mail with a link to a dedicated fileshare though

Hi again, I double checked the fileshare. There is a zip file available called: Traqplan Timeline visual.zip. please let me know if you found it.

​​@@TheProjectCorner Thanks so much for the file, however I could not find the link on your Blog.

Hi again, feel free to reach out on LinkedIn. It is not on the blog as it's not a public site but a free fileshare for newsletter members. I'll share the link to the file through LinkedIn direct message.

@@TheProjectCorner reached out to you on LinkedIn through my wife account, as I am not on LinkedIn. thanks

Hi Ryan, that is too bad. Is it a lot of text? Does it show up differently in the desktop than the service? Thanks for posting the comment, I would like to reproduce the situation and see if I can help out

Large html table with about 8 columns. In desktop it is legible online it goes fuzzy. Increased the pt size of fonts and removed font face style tags but no luck. Happy to share the measure if it helps but will we a day or 2 when I am back in the office. I am sure it is some sort of scaling issue

8 columns of text is a bit much I'd say. Would splitting the text be an option?

Unfortunately it was a project dashboard, so 8 was almost the minimum for that use case. It has worked in other reports with fewer columns but just seems to be a limit

Hi chief, currently not an option sadly. But there are rumours about a program/portfolio layer coming. As soon as I see it I'll let you know. Thanks for commenting

For now ill be creating a display with powerapps to mimic "to-do list" cross projects and add the link to the line itself in it to facilitate cross projects updates. This will enable us to focus dependable task in one project even if it is suboptimal for now!

@@TheProjectCorner Actually went from powerautomate, composed a 2 variable array to filter for the "donor" and "receiver" of dates and went from there for now

Yessss 😞 sad story there, the visual was removed from the official store. There is a depricated cisuals repo on github somewhere. You can get it through there. However, it mjght not be a supported scenario

Thanks for your reply

In case you know a developer, these two pages might be interesting to have, it contains the source code for the timeline storyteller visual. And maybe you could even grab the visual from it. github.com/Microsoft/PowerBI-visuals-TimelineStoryteller github.com/microsoft/timelinestoryteller

Oh my... did they remove the flows? Thanks for letting me know. I will do my best to find out if we can get it without the template.

Hi ThomasDavid, I don't think that's a posibility. On the one hand you don't want them to edit, and on the other you actually need them to. A posibility could be to hide the file and only show the file in a administrator overview or Power BI report. Thanks for sharing your thoughts.

Hi there, I don't think we get the option to hide a tab. That said, because you are working from a browser there is always the option to code your way out of the solution. This change then isn't supported by Microsoft and there is a chance that the code will break other pieces of the solution. Are you working on the native Project.microsoft.com page or through a Power App?

@@TheProjectCorner We are working from the native project as I am not well versed (yet) in power apps. We also link the project straight to teams to facilitate navigation for our people on the floor with no easy access to computers

How is it on more recent videos? I'm curious if the audio changes I made had effect. Hope the content was too your liking apart from that guy that kept talking 😉

Hi John, thanks for this long comment. And I, in part, understand your frustrations. I too struggle at times to work in a web client and crave for the desktop version. Hoewever, the resource capacity planning (by bulk uploading from Excel) can be done in MS Project I believe. That said, I should money where my mouth is, and once the dust settles in the new house (which shouldn't be long now) I'll explore this topic as a new video for you (and the rest of UA-cam). Thanks again for your comment. Regards, Erik

Might be a filter or view issue? Are you able to see the project wkth all tasks in the MS Project desktop client?

Hi, that sounds like a cool little project! Reach out to me through the newsletter subscription please and lets build it together

@@TheProjectCorner Hello, I've successfully subscribed to your newsletter but cannot locate the email address to which I can send my files for further assistance. Could you please provide this information? I'm currently working with a Power BI table named "WO_Schedule" that includes the following columns: New WELL & Type_Intervention RIG Start Date End Date I am attempting to create a Gantt chart using the Deneb visual with Vega-Lite JSON code in Power BI. The chart should display: Dates for each Start and End Date of "New WELL & Type_Intervention" on the X-axis. Each RIG on the Y-axis, with a total of four rigs. The visualization should include horizontal bars for each rig, with each bar segmented according to the start and end date of each "New WELL & Type_Intervention." Furthermore, I need each segment to display the name of the intervention inside the bar and to be color-coded based on the intervention type. Currently, I have managed to display the four horizontal bars for each RIG; however, all bars are in one uniform color. The bars are divided to represent each New WELL & Type_Intervention, but the proportions are off - they are too wide or too short, which prevents the text from being displayed properly within each division. Additionally, every time I attempt to incorporate the color coding provided by ChatGPT, it results in errors. Could you provide guidance on how to adjust the bar dimensions and resolve the color-coding issues? Here are some specifics I'm struggling with: Ensuring that each task bar can display multiple interventions on the same line for a single RIG. Properly configuring the text to be visible within each bar segment. Correcting the JSON code for color-coding without causing errors. Thank you for your assistance!

Strange, there should be a mail sent to you right away. Let me know tomorrow if it still didn't arrive

I would be surprised if it wasn't possible. I am however in between houses atm and won't have much time to dig into it on the short term. But I will get back to you once things are settled. Can you share more about your specific use case?

Oh, that's sad. It might have been removed or renamed. You can grab my file from the fileshare and use that to get the timeline storyteller, but it might still break as a non supported visual. I can have a look and see if I find anything

I found this Redit page with more info: www.reddit.com/r/PowerBI/comments/1b9zj57/timeline_storyteller_power_bi_where_is_it/

Yeah, I found that Reddit to. Didn't help much unfortunately. But thanks for the reply👍

In case you know a developer, these two pages might be interesting to have, it contains the source code for the timeline storyteller visual. And maybe you could even grab the visual from it. github.com/Microsoft/PowerBI-visuals-TimelineStoryteller github.com/microsoft/timelinestoryteller

Thank you so much! It's comments like these that keep me going 👍🏻. Right after the duat settles with the new house, I'll get right to it 😎

My first guess would be that you should merge the date and time columns. However, I'm not 100% sure. If you like you can share the raw formatted table with me (use the mail account from the newsletter subscription) and I can check.

So, here I was, after 100+ days working on the house and setteling in with the family. I finally got that spark back to do some good old UA-cam content creation! Script, Done, Thumbnail, Done, time set asside to do a recording, done... And disaster struck, water on my laptop and it completely died on me 😞. I can continue work as normal (thanks to #M365 and cloud computing) but camtasia and Power BI won't run on my temp machine... hang in there, I'll be back with a new video as soon as possible!

Hmm, that's a nasty experience. Thanks for taking the time to let me know! I'll take a look and make sure there's less.

Updated the settings, should be less ads on the video. Again, thanks for letting me know.

Subscribed to the newsletter or the channel? There is a link to the files in the newsletter, let me know if this helps

I think you might be missing a step? It's difficult to troubleshoot without more details. But feel free to reach out to me on LinkedIn or through the newsletter subscription 🤔

If you subscribe to the newsletter you will have access to my demo file and can follow allong in all the steps. There is a link in the description. Hope that helps.

Hmmm interestingly there is no filter option on the assignments page. There is a "Go to date" Group by Resource or Task and a daily/weekly switch option but no filter on anything. The tasks that are completed aren't marked as complete even. No strikethrough visual for instance. Something to take back to the product group for sure. Thanks for asking.

I.e finding projected risk across attributes long term? New ones creeping up? 🎉❤

Hi Zachary, with the AI visuals and generally speaking AI progress. I do think more options become available. I've recently explored lessons learned options, and projections. Looked promissing as well

Interesting thoughts. Thank you for sharing. I do agree that more information could be shared on that page, same goes for the timeline, shame you can't add columns there

Thanks Rich, it really is 👍🏻

Thank you for the kind words, I'm glad you enjoyed the video. There's so much potential in Loop 😀

Hi Rod, the two are practically merging, which is what I hear: bit.ly/TheNewPlannerPlaylist any specific details you are looking for?

Harsh, but ok 😀. What do you expect your calendar visual to do that isn't easy or possible with the ones I shared in the video? If I find one, I'll let you know.

@@TheProjectCorner hi. Thank for respond)) Ive changed my post, cause Ive found the issue and solved it

Great, ones again, thanks for sharing your experiences

Did the image get removed at the source maybe? Or did your code change in any way?

@@TheProjectCorner No, all my other images in the same source keep being displayed in other charts like the New Slicer.

Ah too bad Kimberly, did you sign up to the newsletter? You can send me the file using that mail address if you like, or screenshots. The format is very strict though, can you double check?

Hi, can you explain the question a bit more? Why do you want the text rotated?

The Lingago Gantt allows for this. The video has a small segment about it. But there is another video in the list (revised lingaro...) that covers it in more detail. Let me know if it helps.

Hi there, the data is available to newsletter subscribers. You can find a link to subscribe in the description. Be aware that the Project Online connection needs a Project Online environment. There is also the download sample option I mention at the beginning of the video that might help you.