Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
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
To learn more about Power BI, follow me on Twitter or subscribe 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
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsStarting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |