Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
F75
Advocate I
Advocate I

Display tenth, hundredth of second

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? 

 

F75_0-1629051042046.png

 

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

4 REPLIES 4
mahoneypat
Microsoft Employee
Microsoft Employee

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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
Super User
Super User

Hi @F75 

 

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

 

F75_0-1629221055277.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.