How can we change the code to personalize the color of each phase of the project ? Thank you.

Is this chart has drill through option?

haha thanks! He is super cool, I agree, thanks for the kind words :)

No, I figured out how to add a column to the table bit but not substantially modify the visual. This video was my first time using Deneb too!

Oh, you even talked about it @12:13 haha.

Probably, that was one of my first thoughts too - I like things to be at least monthly. I will look into it

Davide has added month/year timeline zoom! Here's an updated video: kzfaq.info/get/bejne/a91hp8egqNzdgIE.html

It is totally possible, but would require intermediate Deneb coding skills. If I find out that someone has done this, I will post it here - there's a thread on the community forums about this right now...

Answered this here, cross-linking in case someone else has the same question: www.linkedin.com/feed/update/urn:li:activity:7198339576996720641?commentUrn=urn%3Ali%3Acomment%3A%28activity%3A7198339576996720641%2C7204854094455287812%29&replyUrn=urn%3Ali%3Acomment%3A%28activity%3A7198339576996720641%2C7206439406449090560%29&dashCommentUrn=urn%3Ali%3Afsd_comment%3A%287204854094455287812%2Curn%3Ali%3Aactivity%3A7198339576996720641%29&dashReplyUrn=urn%3Ali%3Afsd_comment%3A%287206439406449090560%2Curn%3Ali%3Aactivity%3A7198339576996720641%29

It's because it's using a datetime stamp in UTC, I think, so everything is shifted by half a day. I poked around a bit and this seems to fix: If you take this chunk of code: { "type": "formula", "as": "start", "expr": "datetime(utc(year(xDom[0]),month(xDom[0]),date(xDom[0])) +(oneDay*datum.sequence))" }, { "type": "filter", "expr": "day(datum.start) == 6 || day(datum.start) == 0 " }, { "type": "formula", "as": "end", "expr": "datetime(+datum.start+(oneDay))" } and replace it with this: { "type": "formula", "as": "start", "expr": "datetime(utc(year(xDom[0]), month(xDom[0]), date(xDom[0])) + (oneDay * datum.sequence) + 12 * 60 * 60 * 1000)" }, { "type": "filter", "expr": "day(datum.start) == 6 || day(datum.start) == 0" }, { "type": "formula", "as": "end", "expr": "datetime(+datum.start + oneDay)" } it'll shift it to the proper position-- Chat GPT wrote the code, though, so validate the output! I'm not a Deneb person.

@@bi-omeyou are a champion thank you

I'm sure it's possible, but would involve Deneb development. Have you seen the latest version though? It lets you scroll up to months and years with the mousewheel (just came out a couple months ago)

The dependencies are a column called "dependencies" that reference the ID of the tasks they depend on, you can comma-separate multiple. I figured out how to add an assignee column after making this video, the code is here (it's using a column called "assignee" as the additional): github.com/chpayton/BI-Files/blob/main/Misc/bacci-gantt-added-column.json I have not managed to figure out how to do month/year/quarter, but there is a thread on it in the Community forums here: community.fabric.microsoft.com/t5/Desktop/Deneb-David-Bacci-Gantt-Chart-How-to-modify-daily-timeline-to/td-p/3488350

Probably, with code, but I'm not sure how!

Anything is possible since you can edit the code, but it would require significant Deneb skills. That would not be me at this point, my to-learn list is about 8 miles long and not getting shorter. 🤣

Oh you might just try a different Gantt btw - the Microsoft one lets you swap the time scale, I have a video on that too. But it doesn’t do milestones etc very well.

@@bi-ome, thanks for the reply. Every Gantt chart app that is available in application library has a limitation, some are not fancy, some needs subscription, very few reflects % complete, etc., though X viz did work for me for an year or wo in terms of formatting but end up asking subscription when I am posting it at web.

@@99wasif David Bacci actually got hired by Microsoft pretty recently, so I am hoping they have him make a good core visual Gantt!

@@bi-ome, it is hope against the hope :)

It's very picky about having all of the fields it needs - I would check your date fields and make sure they're date type (not date time), and that the progress is numeric.

@@bi-ome It was the date hierarchy - you are wonderful btw - thank you for doing this. this is the best

@@jasonknotts2061 Ohhhh the date hierarchy - that makes sense. If you want to do yourself a favor, you can disable that entirely in the report settings for this file and all future files. The date hierarchy is possibly the most hated feature in the history of Power BI (date table 4lyfe 😄). Thank you for your kind words!

@@bi-ome one more q - do you know how to make the # of days in the Days column be Workdays only?

@@jasonknotts2061 I'd be inclined to just remove the days column entirely and replace it with a new column that uses a measure with CALCULATE() and date table filters to remove weekends/holidays. But I am more familiar with DAX than with Deneb JSON templates. Not sure if you're working with a date table, but they are 100% extremely useful for this sort of thing-

Yeah, that was one of the first things I wanted to do with it too - I'll add it to my list. :)

Hello! I realize this comment is forever ago, but Davide just did an update to the template to add month/year zoom. Updated tutorial is here: kzfaq.info/get/bejne/a91hp8egqNzdgIE.html

Did you download his PBIX or the json file directly? If I recall, the PBIX has the version without the data in the JSON - that's where we get it in the video.

@@bi-omeI did use the PBIX file. I resolved the issue by removing the data inputs section within the JSON, thank you for responding though. Your content was incredibly helpful, keep it coming.

La forma más fácil de hacer esto probablemente sería copiar el formato de fecha de una de las columnas de fecha de inicio/fin donde se muestra con mes/días numéricos y reemplazar la sección en la información sobre herramientas que usa nombres largos de meses. Supuestamente, hay un código que puedes usar para configuraciones de localización, pero sería mucho más fácil simplemente cambiar a usar números.

@@bi-ome muchas gracias, lo intentaré

Hello, Deneb is not my specialty area - I gave it a shot a few months ago and it ended up being complicated enough that I would have to actually learn Deneb properly in order to do it (as opposed to trial-and-erroring my way through it). The developer that made the template got hired at Microsoft, though, so I am hopeful that leads to a more robust solution in the core visuals. :)

Update - Davide published a 2.0 version that has month/year (but not week), here's a new tutorial link: kzfaq.info/get/bejne/a91hp8egqNzdgIE.html

The update video here has a days/months/years axis. If it behaves like most, I believe it should "stick" to whatever you have it zoomed to when you published, but I haven't double checked to verify (if you try it and it works let me know!): kzfaq.info/get/bejne/a91hp8egqNzdgIE.html

Thank you, It doesnot default to months with the zoomed in value. I tired multiple ways to debug, It doesn’t work. Please let me know if it works on your end.

Just an update, was able to default the visual to Months and was able to add Hyperlink to external application on the Task column

Possibly, all it’s looking for is a table of tasks with the required columns and no null values (eg with dates). I used totally made up data from Excel for the video. If your column names don’t match, it’ll ask you to map them in setup, or you can rename them inside the visual (it references by field name).

Thanks! That's such a great idea, I will try it and let you know if I get it working. 😄

@@bi-ome I'm having the same issue. Were you able to find a solution?

@@wmbp97 Yes, I had a similar issue with Planner data for this but did get it working... I did a blog post on it here: christine-payton.com/how-to-use-david-baccis-gantt-deneb-template/ In retrospect I am not 100% sure what caused the misalignment on the buckets, but when I went back and made sure that all of the tasks had start and end dates and nothing else had nulls, it worked? It's not clear exactly which part it was getting hung up on.

@@bi-ome Hey thanks for the respose. Perhaps I missed where the solution was addressed in your blog, but I still haven't figured it out. I believe I did determine why my tasks are't being correctly placed within their respective project parent. It occurs when tasks have the same start date. I tried to find/edit the section of JSON which has to do with sorting, priority of sorting, grouping, etc. to resolve it but no luck so far.

Yeah, I figured out how to add "assigned to" as a column but haven't done a video yet - I'll move it up my list. The gist of it is you can copy the code from one of the other columns, paste it in the location you want it, and update references--

@@bi-ome Thank you, I've been struggling doing that. Could you please share the json file with me?

@@danferboc1 Sure thing, here you go. The added column is called Assignee, and it looks in the data for a column called "assignee": github.com/chpayton/BI-Files/blob/main/Misc/bacci-gantt-added-column.json

@@bi-ome Thank you so much Christine, you're amazing! I was able to add that column and another one from my database. One last question, (I know I'm asking too much)..do you know how to change the view from days to month please? Another user asked the same in the comments, it would be great if you can upload that code as well if possible. Thank you so much for your help!

@@danferboc1 Thanks! I don’t know how to change the timeframe from days to months; I did try but it’s not as straightforward as copy/pasting bits as far as I can tell. I’m not a Deneb developer like David, I just hacked at it enough to get it running. It’s on my to-learn list but not high up on the list if I’m honest.

For the template? It's in the video description, but here's the link: github.com/PBI-David/Deneb-Showcase#gantt-chart

Doesn't Project for the Web do Gantt charts natively? If you really want to do it on the Power BI side, you can just do essentially what we do here and rename your fields in the visual to match the template and it should work (assuming you have your data in PBI, if not you can follow this: learn.microsoft.com/en-us/power-bi/connect-data/desktop-project-online-connect-to-data)

Yeah! Glad it helped :)