Forum Discussion

Wluka's avatar
Wluka
Frequent Visitor
1 year ago
Solved

Incorrect Gantt Tooltip Dates

Hello, I have an odd problem with a Gantt chart in Power BI.    My data table shows the data and time, is correctly formatted as date/time – yet when this is shown in Gantt view, the tooltips do no...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    11 months ago

    Hi Wluka,

    Thank you for the update.

    Based on my understanding of the scenario and the provided screenshots, the observed behavior occurs because the Microsoft Gantt visual treats End Dates as exclusive and defaults to US date formatting in tooltips.

    Please find attached the screenshot and a sample PBIX file, which may assist in resolving the issue:

    Kindly ensure that the date columns are typed as Date/Time. Create formatted columns using FORMAT() and add these fields to the Tooltips bucket of the Gantt visual. The tooltip will then display the exact Start and End dates and times without the 24hour shift and in the same date format as the source.

    We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

Shahid12523's avatar
Shahid12523
Community Champion
1 year ago

- Wrong End Date: Gantt tooltips often add +24h if the task ends at the same time next day (e.g., 9 AM to 9 AM).
- Date Format Flip: Tooltips default to MM/DD/YYYY, ignoring your locale.
- Fixes:
- Use FORMAT() in DAX to create custom tooltip fields.
- Convert datetime to text for tooltips.
- Check duration logic to avoid rounding errors.
- Set Power BI regional settings to your preferred locale.