Skip to main content

Power BI

New

Milliseconds as format option for Date/Time

Vote (109) 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 (18)
roloc03's profile image Profile Picture

a5e6d83e 18c5-ea11-a812-000d3a9b112e on 13 Jul 2020 14:58:22

RE: Milliseconds as format option for Date/Time

Surprised not to see this as a date/time formatting option. We use Date/Time in a composite key and the lack of precision is creating duplicate keys.

roloc03's profile image Profile Picture

b7bef276 8fec-4999-a92a-0aa5b0798e89 on 06 Jul 2020 00:11:07

RE: Milliseconds as format option for Date/Time

Much wanted!

roloc03's profile image Profile Picture

728dcbc7 188f-43d5-9322-9a2b68442486 on 06 Jul 2020 00:07:42

RE: Milliseconds as format option for Date/Time

Also needed. I suppose if you are handling any machine created data it is likely to have millisecond timestamps. Also excel is not capable of handling as big data amounts, like typically log or some collected event data.

Therefore I think that this is a must feature and as soon as possible...

roloc03's profile image Profile Picture

a907820c 4e26-4c56-aa04-ab3d588963fb on 06 Jul 2020 00:06:54

RE: Milliseconds as format option for Date/Time

Also need this functionality for milliseconds. It's for my software logs analysis.

roloc03's profile image Profile Picture

1750139c 2447-4078-bd6c-6bd6d5f52ea5 on 05 Jul 2020 23:47:45

RE: Milliseconds as format option for Date/Time

Now the data are stored with milliseconds, chart is shown also properly - just not the time label it self, or table data... Can you add this trivial request?

roloc03's profile image Profile Picture

c46a438d bd7b-4549-9aa2-c27d28b25645 on 05 Jul 2020 23:29:29

RE: Milliseconds as format option for Date/Time

Also would be interesting add the format mm:ss.000 for all short time application such as MotorSport, or sports in general.

roloc03's profile image Profile Picture

7033a4e9 1a43-4a18-81e5-dfbf5ab7b14d 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

177fb9da 2ddf-4932-9821-eae508410bf6 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

73c99f24 5601-4fc6-9e4c-4ac4d5d092b7 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

562ea743 cb98-4443-b77e-fc518d579ce6 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?