Forum Discussion

Auski's avatar
Auski
Advocate 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
Super 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