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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Employee
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.