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

David Bacci made an excellent Deneb template for Gantt visualization in Power BI. In this video, we walk through how to use it and adjust it to use with your own data.

RELATED LINKS
Follow-up blog post on how to add assignees and hook in Planner data:

David's Github:

Get Planner data into Power BI:

0:00 Intro
2:50 Get the template
3:15 Copy the code
3:55 Insert in your PBIX
7:00 Changing the date format
9:12 Setting multiple dependencies
12:27 Changing the task name column width

🪽 CONNECT WITH ME

[macgnf]

thanks for all you do to help us out. always seem to have something I am looking for. also double as asmr for me lmao. I watch tutorials at night to save and fall asleep, you have a very calming voice.

[sidewinder]

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

[WillCooper]

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

[bi-ome]

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

[WadoodAbdul-imgz]

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

[teejaymt]

Nice Updated video salute to you and your efforts Thanks for your time

[cowrulez]

Great video, thanks for sharing this amazing template!

[muradismayilov]

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

[renatojunior]

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

[aycampos]

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

[makavli]

Awesome, simple & educative
Thank you!!

[wasif]

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

[NotGaryGensler]

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

[alanhermans]

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 ?

[chetanshanu]

Thank you for this video! Really appreciate you. I want to change the fonts and everything but cannot seem to do that. Can you please help me?

[asyraftojiman]

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

[jasonknotts]

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.

[Prateeksha]

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?

[conorhogan]

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.

[miastockton]

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