Forum Discussion
Duration as Y-Axis
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!
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
2 Replies
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
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.
