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)
- Merged Idea (3)
RE: Milliseconds as format option for Date/Time
SQL Server 101. Please support datetime which includes milliseconds
RE: Milliseconds as format option for Date/Time
With Market Data coming in from Stream Analytics at a millisecond, usually a conversion from epochtime, it's odd that PowerBI will convert that to a Second format, stripping out the Millisecond. That means there are multiple quotes for that Second so the quotes are summed in the line chart.
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.
RE: Milliseconds as format option for Date/Time
Much wanted!
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...
RE: Milliseconds as format option for Date/Time
Also need this functionality for milliseconds. It's for my software logs analysis.
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?
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.