Skip to main content
Microsoft Idea

Power BI

Needs Votes

Milliseconds as format option for Date/Time

Vote (158) Share
roloc03's profile image

roloc03 on 02 Sep 2016 22:14:37

At the Moment there is no format option within the group "Date Time" to show also the Milliseconds. In Excel the formatting would be "dd.mm.yyyy hh:mm:ss,000" ...

Comments (23)
roloc03's profile image Profile Picture

David Gómez on 05 Jul 2020 23:26:56

RE: Milliseconds as format option for Date/Time

There is an similar idea from 2016 but it doesn´t have a new tag for the power bi team. There are ideas with less votes and you have improved them.

roloc03's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:58

RE: Milliseconds as format option for Date/Time

Tableau can do it....

roloc03's profile image Profile Picture

Wade on 05 Jul 2020 23:24:25

RE: Milliseconds as format option for Date/Time

I wouldn't be as upset about this if you weren't rounding my data! I have a bunch of rows that happened on 09-30-2017 23:59:59.999999, and pulling that into Power BI causes those rows to be rounded to 10-01-01 00:00:00. This really is rather frustrating.

roloc03's profile image Profile Picture

Power BI User on 05 Jul 2020 23:21:19

RE: Milliseconds as format option for Date/Time

Is this function implemented?

roloc03's profile image Profile Picture

David Gomez on 05 Jul 2020 23:18:17

RE: Milliseconds as format option for Date/Time

We need it!!!!! What do we have todo to get this solution?

roloc03's profile image Profile Picture

Scott A on 05 Jul 2020 23:17:47

RE: Milliseconds as format option for Date/Time

Need.

roloc03's profile image Profile Picture

Monte Holyfield on 05 Jul 2020 23:16:17

RE: Milliseconds as format option for Date/Time

Adding to the previous comments, this is critical to support analysis of data with millisecond precision. I need to chart test data gathered from hardware with multiple readings per second. Currently I'm limited on several visuals to showing the average value per second instead of the actual value for each reading.

roloc03's profile image Profile Picture

Power BI User on 05 Jul 2020 23:14:32

RE: Milliseconds as format option for Date/Time

Please add this option as it is necessary for using PowerBI with sports science/athletics reports.

roloc03's profile image Profile Picture

lhlynn on 05 Jul 2020 23:04:48

RE: Milliseconds as format option for Date/Time

This is necessary to get data from Sybase, where id fields often use a timestamp with milliseconds.

roloc03's profile image Profile Picture

Bryan on 05 Jul 2020 22:56:08

RE: Milliseconds as format option for Date/Time

Not having milliseconds on this limits what we can do for scientific research. Really need to add this one!

Merged Idea (3)