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 moreShape 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.
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êsUser | Count |
---|---|
90 | |
88 | |
87 | |
79 | |
49 |
User | Count |
---|---|
153 | |
145 | |
106 | |
74 | |
55 |