Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I see Time / Duration in hh:nn:ss instead of hh:mm:ss (snapshot attached). Is there any particular reason, I may be wrong.
Regards,
Yogesh Maney
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is by design. Power BI supports custom format strings and has inbuilt default formats but it uses the VBA format string pattern.
Here is the VBA documentation: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-v...
Here is the Power BI Documentation: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
In VBA format, the minutes representation is with "n" and thus that is what we show in the formats. If the user is specifying a custom format by themselves, they would need to use "n" for minutes and not "m"
Best Regards,
Community Support Team _ Yingjie Li