Gantt chart adding an extra day to end date

[jeanramonyap]

I am using Gantt 2.2.3 in a visual and when I hover over the start and end dates, there is always an additional day to the end date. It seems that each data point always has to have a full day to display. For example, I have System Downtime for January 1, 2024.

The tooltip will display:

Start Date: January 1, 2024

End Date: January 2, 2024

It cannot understand that I have the downtime ONLY for January 1, 2024. Anyone can figure out this issue?

[jeanramonyap · Accepted solution]

I think I found a solution. Under Duration, I set the Duration unit to hours and set it to 12. This allowed the visual to display same day (start and finish dates) without the addition to be the full day. 

[v-heq-msft]

Hi @jeanramonyap ,
According to your description, in the Gantt chart, your end date is always one day more than the date in the data. To go about solving your problem, first make sure that both the start date and end date in the dataset are formatted correctly as date fields. Sometimes, if the time component is included and not set to the same value (e.g., 12:00 AM for start and end), it can cause the visual object to add an extra day. Next, in the Gantt Chart visual settings, look for any options related to the way the duration calculation or end date is displayed. Adjust these settings to see if they affect the tooltip display.
If the above steps don't solve your problem, please provide us with your pbix file so we can better help you solve the problem.Please remove any sensitive data in advance.

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly