Duration as Y-Axis

[Anonymous]

Hello Community!

Using the Line Chart visualization to plot the following is easy enough:

• Total_Number_Of_Seconds (as a whole number) over time
• Duration (a decimal number, which is Total_Number_Of_Seconds divided by 86,400) over time

Is there any way at all to display the Duration on the Y-Axis in HH : MM : SS format?

Thanks, in advance, for any help!

Duration_Over_Time_pbix

Raw_Data

[Greg_Deckler]

Check out my blog article here: http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

I imagine you could get this into a text column and use a sort by of your numeric duration column.

[Anonymous · Accepted solution]

I can't see a way to display the Duration on the Y-Axis in HH : MM : SS format, unless you try an R visual.  While Power Query has a Duration data type, Power BI Reports do not - durations can only be treated as decimals or as number of seconds as you have it already.  

Vote for this idea to get it improved: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type