Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to order a series by time measured to 0.001 of a second. (hh:mm:ss.000 is my data format) by I am unable to change the format to anything beyond hh:mm:ss. This is causing my results to be bunched on a scatter plot. Can anyone help with formatting the timestamp so that all decimals of the second can be captured?
Solved! Go to Solution.
Hi @wooand,
After research, Power BI desktop can't properly handle the milliseconds. Please review this feature request and vote it. More peoplw need it, maybe it will come ture soon. As a workaround to your scenario, you can convert the time to number of milliseconds in new columns, please create a calculated column using the formula.
NewColumn = FORMAT(Table[Date],"MM/DD/YYYY HH:mm:ss:000")
Then use the NewColumn in your visual.
Best Regards,
Angelia
Hi @wooand,
After research, Power BI desktop can't properly handle the milliseconds. Please review this feature request and vote it. More peoplw need it, maybe it will come ture soon. As a workaround to your scenario, you can convert the time to number of milliseconds in new columns, please create a calculated column using the formula.
NewColumn = FORMAT(Table[Date],"MM/DD/YYYY HH:mm:ss:000")
Then use the NewColumn in your visual.
Best Regards,
Angelia
Thanks for that, and I shall certainly add my thoughts to the feature request.
I just figured out if you create a new column using the Time.Seconds function in M Query you can return the value of the seconds, but it keeps the decimal place after the whole second.
eg: Time.Second([TimeStamp])
returns 18.372 seconds (for example)
Then you can split up the fractions as you see fit, and add to a hierarchy.
maybe. Good Luck y'all!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |