Forum Discussion

wooand's avatar
wooand
Helper II
8 years ago
Solved

Time Decimals

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 b...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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:smileyhappy:. 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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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:smileyhappy:. 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

wooand's avatar
wooand
Helper II
8 years ago

Thanks for that, and I shall certainly add my thoughts to the feature request.