Building great Deneb Gantt visuals, by almost cheating 😉
Вставка
- Опубліковано 5 лип 2024
- I'm looking at the Deneb visual, and asked my new best friend Vicky Vega (GPT AI) to assist. Find out what Deneb & AI can accomplish together!
👉 Watch next - Gantt chart visuals playlist
• GANTT charts in Power BI
Davide has a new version of his Gantt available: / davbacci_powerbi-vizua...
I created 2 GPTs, try them out here:
🤖1: The PMO Pro, assists a project manager with anything PM-related (based on PMI, Scaled Agile or OKR). bit.ly/The_PMO_Pro
🤖2: Vicky Vega, assists Power BI report creators in building custom visuals using Vega or Vega-Lite (a JSON code that is used in the Deneb custom visual). bit.ly/VickyVega
*) Using GPT's requires a ChatGPT Plus subscription.
📨 The TPC Newsletter (subscribe to get free content):
eepurl.com/dsm7dj
⌛ Learn about timeline visuals in Power BI:
• Timeline visuals in Po...
📊 In case you need a Gantt chart visual in reports:
• GANTT charts in Power BI
📆 Calendar visuals inside Power BI:
• Calendars in Microsoft...
🚀Projectum Power PPM:
projectum.com/power-ppm/
📜The Project Corner blog:
www.theprojectcornerblog.com
LET'S CONNECT:
🧑💼 Follow Me On LinkedIn- / erikvanhurck
🐦 Follow Me On X - / erikvanhurck
Chapters:
00:00 Introducing Deneb
01:30 Vega and Vega-Lite
02:35 Examples and a first try in the Vega Editor
03:50 Simple Gantt bar in Vega-Lite
05:05 using the Gantt example in Deneb
07:45 Expert example Gantt chart in Deneb
09:30 Introducing my GPT model: Vicky Vega
11:40 first result in Deneb
12:50 adding Percent complete in Deneb Gantt visual
16:10 end result
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: ua-cam.com/video/tOhAxulPAoc/v-deo.htmlsi=7ReC9WF-ZUPVP6NK
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
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
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 UA-cam, 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 UA-cam adds altogether)?
Now it worked much better