Forum Discussion
How do display duration properly?
You should be able to add a claculated column to convert to a time.
A quick experiment gives me this formula to take a duration in minutes and turn it into a time (using time as the field with the minutes in):
=TIME(FLOOR([Time]/60,1),FLOOR(MOD([Time],60),1),MOD([Time],1)*60)
this will probably not work for times above 24 hours though, I'd expect them to wrap aroung to 0:00 at that point.
Anonymous, but how can I use such a value in column (bar) chart? As I can see it I can't use values of Data Type Time, I can only count such values. So even though the conversion works, I'm afraid it doesn't help me.
Greg_Deckler, I'm looking forward to that article. Please let me know where to find it once released.
gusly - The article was published, you can find it here: http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Hi,
thanks for the blog post, helped me a lot to finally use Power BI for my flight book.
Using this calculation works for me in the table visual, but somehow not in a column chart.
As a workaround I have to use a duration in seconds or minutes for the chart, but this makes the axis numbering confusing as it shows thousands of seconds, or houndreds of minutes.
Do you have any tips to make the chart display hours:minutes on the axis?
Best regards,
Phil
Did you find your answer to this? I am looking to display duration in hours or days
