The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
I want to format a clustered column bar chart in hh:mm:ss
like this
I've made a measure showing the average of hh:mm:ss i DAX
Any suggestions?
/Claus
@Claus-Vad , Assume time is in second. Use new Dynamic String format
Time format
"""" & QUOTIENT([net time],3600) & ":" & QUOTIENT(mod([net time],3600),60) & ":" & round(mod(mod([net time],3600),60),0) & """"
refer
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/