Forum Discussion

Auski's avatar
Auski
Icon for Advocate I rankAdvocate I
3 years ago
Solved

Stacked Bar Chart with Duration

Hi all,   I am looking at creating a stacked bar graph in PBI for each agent using duration (similar to the excel screenshot below). However when I do add duration to the x-axis, count is my only d...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Auski , Have time in second. Use new dynamic string format and give this format and use

     

    """"& QUOTIENT([net],3600) &":" & QUOTIENT(Mod([net],3600),60) &":" & round(MOD(Mod([net],3600),60),0) &""""

     

     

     

     

    Here net is measure in second I converted for format time

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Auski , Have time in second. Use new dynamic string format and give this format and use

 

""""& QUOTIENT([net],3600) &":" & QUOTIENT(Mod([net],3600),60) &":" & round(MOD(Mod([net],3600),60),0) &""""

 

 

 

 

Here net is measure in second I converted for format time

  • Auski's avatar
    Auski
    Icon for Advocate I rankAdvocate I
    3 years ago

    amitchandak You my friend are a genius. Thank you very much for that. I doubt I would have even considered dynamic string format as a solution as it wasn't even activated in the settings.

    So, this is undoubtably the solution as per screenshot below, however the x-axis doesn't like the format. Do you know if there is a work around here.... or do you think I might have done something wrong down the line?

     

     

    Of course I can simply turn off the axis and get a satisfactory result, but might be helpful for anyone in future.

    Thank you again!!