cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpfarhat Frequent Visitor
Frequent Visitor

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!

 

Duration_Over_Time_pbix

Raw_Data

1 ACCEPTED SOLUTION

Accepted Solutions
Steve_Wheeler Established Member
Established Member

Re: Duration as Y-Axis

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 2
Steve_Wheeler Established Member
Established Member

Re: Duration as Y-Axis

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

Highlighted
Super User
Super User

Re: Duration as Y-Axis

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!