topic Re: Gant chart 3.0.12.0 in DAX Commands and Tips

Gant chart 3.0.12.0

Gretha28 — Fri, 14 Feb 2025 08:50:48 GMT

Hello,
Hope someone knows the answer! I use a gantchart and want see every step (codenr) in a proces. Some steps are at 1 day, the start and enddate ar the same.
In my visual I use for:
legend Codenr
Task: clientnr
Startdate: the startdate from a codenr
Duration: count days from startdate to enddate

I see now in the visual the codenr in time, but don't see de codenr when the startdate is the same as enddate. (even when I tried datetyp a day). Hope someone can help me, thank you!

Re: Gant chart 3.0.12.0

grazitti_sapna — Fri, 14 Feb 2025 09:07:16 GMT

Hi Gretha28,

In your Gantt chart, the issue occurs because tasks with the same Start and End Date have a duration of zero, making them effectively invisible in the chart. Here is a solution to fix this issue:

Modify your duration measure so that it ensures a minimum duration of 1 day when the start and end dates are the same:

Duration =
VAR DaysDiff = DATEDIFF('Table'[Startdate], 'Table'[Enddate], DAY)
RETURN IF(DaysDiff = 0, 1, DaysDiff)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Re: Gant chart 3.0.12.0

Gretha28 — Fri, 14 Feb 2025 09:32:17 GMT

thx for your reaction, I tried it but it still doesn't work...