How to use David Bacci's Deneb template: Power BI Gantt w/ milestones, dependencies, and phases

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 พ.ย. 2024

ความคิดเห็น • 88

  • @bi-ome
    @bi-ome  6 หลายเดือนก่อน +5

    UPDATE: The Gantt has been updated to include month/year zoom! I made an updated video for this here: th-cam.com/video/5w1tdoCvyPM/w-d-xo.html
    You can read about the new features and get the files here: www.linkedin.com/posts/davbacci_powerbi-vizualization-powerbitips-activity-7195512264987148288-24FT?

    • @boudj73
      @boudj73 5 หลายเดือนก่อน

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

    • @avudurthisrinivas8841
      @avudurthisrinivas8841 3 หลายเดือนก่อน

      Is this chart has drill through option?

  • @sidewinder0984
    @sidewinder0984 ปีที่แล้ว +3

    Just stumbled across the Reddit post and then found this. Couldn't have been more perfect timing! Thank you!!

  • @bi-ome
    @bi-ome  ปีที่แล้ว +4

    Y'all! I've been informed that Deneb has a built-in find and replace you can use with control+F instead of pasting into a text document. Might save you some time. :)

  • @WillCooper1
    @WillCooper1 ปีที่แล้ว +2

    Gantt charts are super popular. I see a ton of interest in this topic. Thanks for sharing your knowledge how to use this Power BI template! 🙂

  • @WadoodAbdul-im6gz
    @WadoodAbdul-im6gz ปีที่แล้ว +1

    just add the sheet with a new table and just turn the columns deneb! I tried works fine! Thank you so for the tool!

  • @muradismayilov7634
    @muradismayilov7634 ปีที่แล้ว +2

    Hi Christine, many thanks for the video. Any idea how to add baseline function to this template ?

    • @bi-ome
      @bi-ome  ปีที่แล้ว +1

      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!

  • @bi-ome
    @bi-ome  8 หลายเดือนก่อน +1

    I did a follow-up post here that shows how to add an Assignee column and use this template with Planner data here: christine-payton.com/how-to-use-david-baccis-gantt-deneb-template/
    For anyone looking for a solution to displaying by different date periods like month/quarter, Greg Philps did a post with a riff on the Bacci chart here and says you can modify the LabelExpr and timeFormat variable in his version to that effect: forum.enterprisedna.co/t/deneb-examples-enhanced-gantt-chart/61389

  • @cowrulez
    @cowrulez 15 วันที่ผ่านมา

    Great video, thanks for sharing this amazing template!

  • @jasonknotts2061
    @jasonknotts2061 4 หลายเดือนก่อน

    Hi Again!! this is my rationale so far in wrapping my mind around how the "Days" output could be modified so that it is adjusted for Workdays and Holidays - the json code formula (expr) to calculate the days between the "Start" and "End" date to derive the "Days" number is: datetime(+datum.end - datum.start)/oneDay) which outputs the total days in a"daily" increment - in order for it to give us days that are workdays (minus holidays and weekends) we would need a function that was activated based on the array of dates from Start to End prior to the calculation - I'm sure this has already been worked out somewhere, not easy to find though - I wish we could somehow manipulate the JSON with DAX. At this point I can't figure out the best way to approach this.

  • @Prateeksha1993
    @Prateeksha1993 ปีที่แล้ว +1

    How do I find dependencies within the json that we get through the Planner to Power BI connection (based on your video on connecting Planner to PBI)?
    If I wanted to add person name to this visual, can I do that?
    It is also possible for it to show the timeline by month or quarter instead of by day?

    • @bi-ome
      @bi-ome  ปีที่แล้ว +1

      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

  • @renatojunior2941
    @renatojunior2941 10 หลายเดือนก่อน

    Awesome!!!! Great Video, thank you Christine!

  • @laviecest5811
    @laviecest5811 8 หลายเดือนก่อน

    This is super helpful. Thank you!

  • @99wasif
    @99wasif 10 หลายเดือนก่อน +1

    @christine Payton. Thank you so much. Its amazing. I have one query, since I have a project comprises of many years, I wanted to display the Gantt Chart in year as time scale? Is it possible? Thanks again.

    • @bi-ome
      @bi-ome  10 หลายเดือนก่อน +1

      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. 🤣

    • @bi-ome
      @bi-ome  10 หลายเดือนก่อน

      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.

    • @99wasif
      @99wasif 10 หลายเดือนก่อน

      @@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.

    • @bi-ome
      @bi-ome  10 หลายเดือนก่อน +2

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

    • @99wasif
      @99wasif 10 หลายเดือนก่อน

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

  • @aycampos
    @aycampos 4 หลายเดือนก่อน

    that was awesome, thank you for showing us the way!

  • @alanhermans9921
    @alanhermans9921 ปีที่แล้ว +1

    Hello, thanks for the great video, really valuable! I was wondering if there were any possibility to add parents to the chart to toggle to a higher level view. Do you know ?

    • @bi-ome
      @bi-ome  ปีที่แล้ว +1

      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...

  • @makav3li665
    @makav3li665 5 หลายเดือนก่อน

    Awesome, simple & educative
    Thank you!!

  • @NotGaryGensler
    @NotGaryGensler 29 วันที่ผ่านมา

    Is it possible to add hours and minutes to the start and end dates? such as "MM/DD/YYY HH:mm" ?

    • @bi-ome
      @bi-ome  29 วันที่ผ่านมา

      I am sure it's possible, but I'm not the best person to ask for how - I didn't make the template and I'm not a Deneb developer, I just wanted to use this template and thought I'd share how I got it up and running. You might try in the PBI community forum, they have a category for custom visuals and Debeb there--

  • @danilochinnici358
    @danilochinnici358 5 หลายเดือนก่อน

    Hello, first I would like to thank you for the excellent content.
    I'm trying a problem and I'm not able to solve it, if you can help me I'll be grateful.
    By zooming in on the graph visualizing the days, we can see that on weekends (Saturday and Sunday), it is shaded.
    However this shading for me is getting on Sunday and Monday, would you know how to help me to correct this?
    Thank you in advance

    • @bi-ome
      @bi-ome  5 หลายเดือนก่อน

      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

  • @luisasaraiva1671
    @luisasaraiva1671 7 หลายเดือนก่อน

    It's an excellent project! Do you know if it is possible to freeze the columns until "progress"?

    • @bi-ome
      @bi-ome  6 หลายเดือนก่อน +1

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

  • @miastockton3377
    @miastockton3377 4 หลายเดือนก่อน

    Is it possible to add scroll bars instead of using click and drag to expand the chart?

    • @bi-ome
      @bi-ome  4 หลายเดือนก่อน

      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)

  • @dheepakkumar9072
    @dheepakkumar9072 ปีที่แล้ว

    about right time you posted this! Thanks for the great video.. definitely learned a thing or two here.
    I just have this one question, Is it possible to change the date range (timeline on the top) as right now it is displayed as day by day, Is it possible to make it monthly or quarterly? along with year displaying next to the month's name

    • @dheepakkumar9072
      @dheepakkumar9072 ปีที่แล้ว

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

    • @bi-ome
      @bi-ome  ปีที่แล้ว +1

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

    • @bi-ome
      @bi-ome  6 หลายเดือนก่อน +1

      Davide has added month/year timeline zoom! Here's an updated video: th-cam.com/video/5w1tdoCvyPM/w-d-xo.html

  • @conorhogan7575
    @conorhogan7575 4 หลายเดือนก่อน

    I have been having some success with this visual, but recently ran into an issue where the gantt chart is displaying -1 day from what is listed in the data. No idea what's causing that to happen but it's frustrating.

    • @bi-ome
      @bi-ome  4 หลายเดือนก่อน

      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.

    • @conorhogan7575
      @conorhogan7575 4 หลายเดือนก่อน

      @@bi-omeyou are a champion thank you

  • @Kidpambi
    @Kidpambi ปีที่แล้ว +1

    Hello! If there's any possibility you could discover a method to present the Gantt chart on a weekly or monthly basis, it would be greatly appreciated. Thank you in advance for any insights you might have (in case you come across a solution)

    • @bi-ome
      @bi-ome  ปีที่แล้ว +1

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

    • @bi-ome
      @bi-ome  6 หลายเดือนก่อน

      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: th-cam.com/video/5w1tdoCvyPM/w-d-xo.html

  • @jackwilliams5960
    @jackwilliams5960 7 หลายเดือนก่อน

    The json text contains his data pre entered hence I am not sure how you link it to new data, please advise?

    • @bi-ome
      @bi-ome  7 หลายเดือนก่อน +1

      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.

    • @jackwilliams5960
      @jackwilliams5960 7 หลายเดือนก่อน

      @@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.

  • @sybamunki
    @sybamunki 11 หลายเดือนก่อน

    can this be used with the Project for Web data model? It has a lot of features some users are asking me for

    • @bi-ome
      @bi-ome  11 หลายเดือนก่อน

      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).

  • @asyraftojiman6801
    @asyraftojiman6801 9 หลายเดือนก่อน

    David Bacci is Super Cool, You are Super Cool Christine Payton. Thank you for sharing !!

    • @bi-ome
      @bi-ome  9 หลายเดือนก่อน

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

  • @jasonknotts2061
    @jasonknotts2061 4 หลายเดือนก่อน

    I keep getting an "Invalid SVG path" error - incorrect parameter type, that I can't figure out. The 2.0 PBIX file visualization is fine, I pasted the JSON from that file, followed your instructions - the only really difference is possibly the data format? I moved it to a CSV file and thought that it would be help - but nope still get that same SVG error.

    • @bi-ome
      @bi-ome  4 หลายเดือนก่อน +1

      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.

    • @jasonknotts2061
      @jasonknotts2061 4 หลายเดือนก่อน

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

    • @bi-ome
      @bi-ome  4 หลายเดือนก่อน +1

      @@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!

    • @jasonknotts2061
      @jasonknotts2061 4 หลายเดือนก่อน

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

    • @bi-ome
      @bi-ome  4 หลายเดือนก่อน

      @@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-

  • @danferboc1
    @danferboc1 ปีที่แล้ว

    Great video! Do you know how to add more columns between "Start" and "End" dates in the visualization? Thank you!

    • @bi-ome
      @bi-ome  ปีที่แล้ว

      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--

    • @danferboc1
      @danferboc1 ปีที่แล้ว

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

    • @bi-ome
      @bi-ome  ปีที่แล้ว

      @@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

    • @danferboc1
      @danferboc1 ปีที่แล้ว

      @@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!

    • @bi-ome
      @bi-ome  ปีที่แล้ว +2

      @@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.

  • @MauroAMAUTCHACON
    @MauroAMAUTCHACON 6 หลายเดือนก่อน

    Hola, me podes ayudar por favor, como hago para cambiar al español los dias en el tool tip

    • @bi-ome
      @bi-ome  6 หลายเดือนก่อน +1

      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.

    • @MauroAMAUTCHACON
      @MauroAMAUTCHACON 6 หลายเดือนก่อน

      @@bi-ome muchas gracias, lo intentaré

  • @TheNunocampino
    @TheNunocampino 11 หลายเดือนก่อน

    Wow, you are amazing!!! I've adapted this template to my Power BI which I pulled from MS Planner through Power Automate, following your previous videos. The result is great! However, I am having an issue. In my Planner, I've set the Buckets as the Project names and listed the related tasks in each bucket. Now, adapting to the template, I've added the Bucket names into the "phases" field. It works but the tasks are not grouped under each respective project... this must be an easy thing to adapt in the script but I don't know how to do it. Can you please help?
    Thank you a lot!

    • @bi-ome
      @bi-ome  11 หลายเดือนก่อน +2

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

    • @wmbp97
      @wmbp97 8 หลายเดือนก่อน

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

    • @bi-ome
      @bi-ome  8 หลายเดือนก่อน

      @@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.

    • @wmbp97
      @wmbp97 7 หลายเดือนก่อน

      @@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.

  • @ChanakyaPola
    @ChanakyaPola 4 หลายเดือนก่อน

    Is there a way we could default the axes to months instead of days?

    • @bi-ome
      @bi-ome  4 หลายเดือนก่อน +1

      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!): th-cam.com/video/5w1tdoCvyPM/w-d-xo.html

    • @ChanakyaPola
      @ChanakyaPola 4 หลายเดือนก่อน

      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.

    • @ChanakyaPola
      @ChanakyaPola 4 หลายเดือนก่อน

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

  • @mahdinaouali1099
    @mahdinaouali1099 9 หลายเดือนก่อน

    Hi Christine
    I like ur video it's very nice
    QUESTION
    Could you please change the days to weeks?
    Thanks

    • @bi-ome
      @bi-ome  9 หลายเดือนก่อน +1

      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. :)

    • @bi-ome
      @bi-ome  6 หลายเดือนก่อน

      Update - Davide published a 2.0 version that has month/year (but not week), here's a new tutorial link: th-cam.com/video/5w1tdoCvyPM/w-d-xo.html

  • @JonathanWhittle-g8j
    @JonathanWhittle-g8j 8 หลายเดือนก่อน

    Anyone able to help configure this for Project for the Web?

    • @bi-ome
      @bi-ome  8 หลายเดือนก่อน

      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)

  •  ปีที่แล้ว

    can you please include the address. You can not read it from your video

    • @bi-ome
      @bi-ome  ปีที่แล้ว

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

  • @Chris-wb1pz
    @Chris-wb1pz ปีที่แล้ว +1

    Just stumbled across the Reddit post and then found this. Couldn't have been more perfect timing! Thank you!!

    • @bi-ome
      @bi-ome  ปีที่แล้ว

      Yeah! Glad it helped :)