Forum Discussion
Display HH:MM:SS
I am tryting to achive this
I have data in Seconds and In I have coverted it to hh:mm:ss using this http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486.
I was able to display it like below(as Second) but could not display it as hh:mm:ss on the graph,
2 Replies
Yeah, because there is no true "Duration" format, when you convert it to HH:MM:SS it ends up as text instead of a numeric data type. What is really needed is a "Duration" format that leaves it as numeric seconds but displays as HH:MM:SS. It's been requested for years but the product team has never done it.
They now have a duration data type, but don't go over 24 hours -- it gets confused
