Forum Discussion

GStewart99's avatar
GStewart99
New Member
2 years ago
Solved

Issue with time display

I've recently encountered an issue where time is not displaying correctly in Power BI compared to the source data.  Data type is time, format is hh:nn:ss in both Power BI and Excel, however, Excel will display 00:01:27 while Power BI will display 00:01:26.  No data summarization on the column in the Power BI table.  Many of the rows of data are correct, but more than a handful are off by a second.  Has anyone encountered this and know of a solution?

Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    Try to ceate a custom column in Power BI to round the time values to the nearest second to ensure consistency :

    = Table.AddColumn(YourTableName, "RoundedTime", each Time.From(Time.ToText([YourTimeColumn], "hh:mm:ss")))

2 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

    Try to ceate a custom column in Power BI to round the time values to the nearest second to ensure consistency :

    = Table.AddColumn(YourTableName, "RoundedTime", each Time.From(Time.ToText([YourTimeColumn], "hh:mm:ss")))