Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Gretha28
New Member

Gant chart 3.0.12.0

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!

2 REPLIES 2
Gretha28
New Member

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

 

grazitti_sapna
Super User
Super User

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!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.