Forum Discussion

Avichal's avatar
Avichal
Frequent Visitor
6 years ago
Solved

Time Duration and Time Graph Plotting

Hello Everyone,

 

I am new to Power BI. Looking for some help. Earlier I use Excel and Power Point to present Weekly Report. Now i have started in Power BI. I use to compare average resolve time weekly. 

 

So First I need duration in hh:mm:ss format which includes more that 24 hour (Example 28:40:32). Second I need to plot bar graph with respect to time.

 

I am attaching screenshot 1 how it use to be appear in Excel. 

 

Problem I am facing if in case I convert duration in HH:MM:SS format then it is in text format so when plotting graph then it take count.

 

Please help. 

 

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Avichal ,

    You can try this:

    1. Duplicate column of ‘Duration’.

    2. Split ‘Duration – Copy’ with ‘:’.

    3. Add a custom column.

    =[#"Duration - Copy.1"]*3600+[#"Duration - Copy.2"]*60+[#"Duration - Copy.3"]

    4. Remove columns.

    5. Create a line chart, put ‘Seconds’ in ‘Values’ and ‘Duration’ in ‘Tooltips’.

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Have you tried time on the axis? By dragging it into the axis property of the graph and it still shows count.

    • Avichal's avatar
      Avichal
      Frequent Visitor
      6 years ago

      Hello Amit,

       

      Thanks for your help but it doesn't work :(

      amitchandak wrote:

      Have you tried time on the axis? By dragging it into the axis property of the graph and it still shows count.

       

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Avichal ,

    You can try this:

    1. Duplicate column of ‘Duration’.

    2. Split ‘Duration – Copy’ with ‘:’.

    3. Add a custom column.

    =[#"Duration - Copy.1"]*3600+[#"Duration - Copy.2"]*60+[#"Duration - Copy.3"]

    4. Remove columns.

    5. Create a line chart, put ‘Seconds’ in ‘Values’ and ‘Duration’ in ‘Tooltips’.

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Avichal's avatar
      Avichal
      Frequent Visitor
      6 years ago

      Hi Icey,

       

      Thank you for your response. It work for me just if you can help me with one more thing :- Is there a way I can show data label with duration value ?