Forum Discussion

Wluka's avatar
Wluka
Frequent Visitor
11 months 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...
  • v-pnaroju-msft's avatar
    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.