Display tenth, hundredth of second

[F75]

I want to display time as 1:42.10 (minutes, seconds, fraction of second) format, not as text but time. I will use this to sort. I can use "n:ss" which will display as "1:42". 

Is there a custom formatting for fractions of second avaialble? 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2019-feature-summary/#customForm... 

[mahoneypat]

Please see this solution.  I would keep your column as a decimal in days, so you can sort and aggregate, but then make a measure using the same approach as shown for the column in this post.

Solved: Convert seconds column into duration column hh:mm:... - Microsoft Power BI Community

Pat

[F75]

Text format will not work in my visuals. Excel has hh:nn:ss.00 format, Power BI does not.

There is this idea, if you find it useful please vote. https://ideas.powerbi.com/ideas/idea/?ideaid=2199e3f6-07c1-4256-88d7-a2189985142e

[MFelix]

Hi @F75 

Have you tried to use .00 after the seconds notation something similar to excel that uses h:mm:ss.00 should work.

[F75]

@MFelix Thanks. I tried, and this is what it displays. Not sure what/how it is converting?