The Project Corner is dedicated to helping the Project Management Office (PMO) succeed, with Microsoft technology. This includes Microsoft Project, Project for the web, Planner, Power BI and other Project Management related software.
Hi, my name is Erik van Hurck, welcome to The Project Corner!
I'm a consultant and Microsoft MVP with a focus on Project and Portfolio Management software. I have a Ask me anything mind set. So, if you are curious about anything related to the above mentioned tools let me know and I might do a video or blog article about it.
Пікірлер
thanks for sharing a great explanation
thanks. btw "parameter" is pronounced "param-eter"
Damn that Dutch accent 😉. Thanks for the tip, I'll try and remember it for the next video.
@TheProjectCorner Hello, great work as usual! Where can we get the datasource/spreadsheet you used in this video? I subscribed to the NewsLetter but cant find it. Thanks
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
My text is still fuzzy when rendering a table, a shame as it was really easy to work with the visual
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 there, to your knowledge is there any ways to link task between different project for the web? I am at a loss at the moment and my 2 avenues are to write as a note the ID of the task in another project for the web and use power automate to sync them but thats limited to 1 task and also quite extensive... We could also go the oneplan route, sync to project online and master project from there, but again aaaa lot of work + 2 subscription
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
great explanation of however, I can not find Timeline Story visual
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
Hi! I know this was 3 years ago but have been trying to set up this exact same flow and the template does not exist anymore. Do you know where I can find this template?
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.
Do you know how to make the online Excel file read-only for non-admins while still giving them to rights to fill in the form and save it so it gets saved in the Excel? When making it read-only now, when the users fill in the form it doesn't get added to the Excel. Thanks!
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.
Trying my luck. Do you have any idea how to make the Charts go away. They are simply not great and causing confusion while we use power bi to display what we need
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
Your swallowing is oddly loud.
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 😉
As a master scheduler , I find the MS project lacks the resource capacity planning capabilities. It misses bucket planning which is essentially manually editing the assignments for a period. If only there was a native schedule tool to load the monthly/weekly allocation from an excel sheet (easier to modify the allocation for the period). Most of the scheduling tools follow linear loading calculated based on planned start and finish, Primavera P6 allows for resource curves but still lacks the bucket loading features. ( In real world projects, multiple resources support multiple projects and it's not a uniform allocation. So capturing effort is important for capacity planning/demand generation. (Rant over). PS I hate working on web version of any scheduling software (MS project, Primavera web version, JIRA and other softwares which forces you to click a thousand times)
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 KZread). Thanks again for your comment. Regards, Erik
Thank you!! can you help me? I have only one project in pwa, and i can’t see the tasks.. just show the project title
Might be a filter or view issue? Are you able to see the project wkth all tasks in the MS Project desktop client?
I would like to contact you to share a Gantt chart that I am trying to create but so far have had no success.
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
Is it possible to design a calendar and make it a fixed model, then add variable data to it every month without changing the calendar model again? Thank you for your wonderful effort in explaining. I have benefited greatly from you
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?
Can`t find timeline storyteller when I search for it.
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👍
Your content is fantastic, thank you so much & keep going!
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 😎
Interesting video, thank you. How do you configure the data when using MAQ Calendar, because the records do not appear to me at a certain time. It's like it lasts all day. I have the time in another column.
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.
8 months ago, the (moving) journey started. This week, we get the key to the house! 🎉
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 KZread 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!
Unfortunately XVIZ Price for Share at web too much almost 4000$ per year
Ridiculous amount of ads on this video dude
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.
How can I insert the risk matrix into my Power BI. Could you please share that risk matrix template. I already subscribed but I still can't find the matrix.
Subscribed to the newsletter or the channel? There is a link to the files in the newsletter, let me know if this helps
Hello, Thanks a lot for the video, yet; am currently having an issue, where when I applied steps shown by you, the matrix it self doesn’t appear. Do you any solution for this issue?
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 🤔
Thank you so much for an overview of the tool. This looks very useful; I am trying to use it to generate some reports. How did you get the project phase start and end dates as well in the table view on Power BI? After doing the Unpivot step, I only have 2 columns with the attributes and the values. Thanks in advance!
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.
Great review, is it possible to filter out completed tasks?
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.
Projections and forecasts?
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
Thanks for sharing. What I can't understand is why it doesn't give the full Task information like number, task structure (subtask), WBS number or at list let the task be filtered by task number, bucket, or label. If you have the same task name in the project is a nightmare to know which is which. I also can't understand why it show all tasks, in the time frame selected even the one already complete or scheduled a head. Good idea, but poorly execute by MS.
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 for sharing Erik. My team stumbled into this a few months back...GAME CHANGER!!!!
Thanks Rich, it really is 👍🏻
Thank you for the clarity and excellent examples of workflow- well done.
Thank you for the kind words, I'm glad you enjoyed the video. There's so much potential in Loop 😀
Have you heard any additional details on the integration of P4W into the Planner app?
Hi Rod, the two are practically merging, which is what I hear: bit.ly/TheNewPlannerPlaylist any specific details you are looking for?
The problem has solved. OKVIZ calendar does not support date/time format like "24.12.2024 01:12:48" Power bi works properly with this, but Okviz - not. And Okviz losts some data. To avoid this situation change your date format to: "24.12.2024", delete time. If you need time - use additional column with "24.12.2024 01:12:48".
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
My HTML content suddenly stops displaying the image, first it works just fine, then after a while it stops working. Any ideas?
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.
This didn't work for me. I followed step by step. Not sure what I could be doing wrong.
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?
how rotate 90d the value?
Hi, can you explain the question a bit more? Why do you want the text rotated?
How can we create this visual of we have multiple dates (different tollgates) between start and end date. ? For eg: data set consists of Project Name, phase 1 end date , phase 2 end date, phase 3 end date, finally project end date.
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.
Very cool, I would love to follow along but have no clue how the dataset should look like. I am a beginner. Please post it somewhere as an excel file or so thanks!
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.
Very Good!!!!
Thanks Henrique! Glad you like the video have a great 2024!
Thanks for this video I designed a risk dashboard from SharePoint but I have not been able to design the matrix. I will try this out
Thanks for the comment, let me know if you run into any issues
blurry screen
Hi Guyb, it is one of my older video's. But could it be your connection? I watched it agsin on mobile snd the text is readable. Thanks for the comment, newer videos are in 4k resolution.
This was by far the most useful one I have found. Thank you so very much for this guide. I still had a question, you said that we can change the default work templates for the entire team from the Summary in the Power App to that Project. What if I want to assign different work hours for different people in a team. Do I change their individual templates? What do I do about the template that's in the summary? It says it's a required field. Does putting a different schedule from the one in the summary give different schedule only to those people or is there something else? Please elaborate on this also
Hi Yash, I wrote an article explaining a lot regarding the calendar settings. Hope this helps: www.mpug.com/what-you-need-to-know-about-calendars-in-project-for-the-web/
Do you know if this solution is able to manage activities that run multiple times within timeline?
It would need to be coded, but yes I believe it could if the source data is correctly formatted
9:00 you put all tasks on finish to start dependancy with the tasks being 3 weeks then 2 weeks. Doesn't that make the total task duration 5 weeks aka 35 days? Why is the summary task saying 25 days? I am a new user to Project softwares in general. So I don't understand if I am missing something. Please tell on this
Hi Yash, Project for the web (and other project software) views a week as a workweek. Meaning that 1 week is 5 (work)days. So the calculation is 3+2=5 weeks, 5 * 5 = 25 days. Hope the calculation makes sense, thanks for watching the video and commenting.
Christine Payton did an excellent job with a review of the Deneb Gantt example. If you want to learn how to use it for yourself, I'd recommend watching her video: kzread.info/dash/bejne/poOco9qunLOnn8Y.htmlsi=7ReC9WF-ZUPVP6NK
where can i find the image of 9-matrix?
Hi, its in the files storage you get access to once you sign up to my newsletter (link in the desription).
The video seems Tao be interesting. But getting 4 time advertising within the first 5 minutes of the video I stopped watching.
Hi there, Thank you for this valuable comment. This is indeed unacceptable and I do apologize. I will look into what's wrong here, because the add locations are auto assigned by KZread, I might need to tweek that for this video. I hope you will return for the full video in the future. Can I also advice you look into the Brave browser (which removes KZread adds altogether)?
Now it worked much better
Thanks
And thank you Varun! You are a valued fan of TPC for sure!
@@TheProjectCorner It is an honor that you have said this
Hello thanks for the awesome video - in my MS office 365 I can't get the features for free, I would have to pay like in a marketplace. Do you know why?
Hi Magdalena, there are two situations here. First: Power BI is a separate product from office 365. Second, some custom visuals are designed by 3rd party organizations that have a license structure of their own. Hope this answers up your question
Inportant features lacking in Project for the web are baseline and lead/lag
Yes, I do however remember seeing both on the roadmap
Wow. Nice to know. Next time when you meet these guys, do ask them for more Baselines provision in the Desktop client version. Sometimes, 11 are not enough for bigger projects. My humble ask
Haha, I can. But don't expect much as they (and I) don't agree