Forum Discussion
Advocate IStacked 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 display option.
What I am trying to recreate:
Excel:
Y-Axis = Agent Name, X-Axis = Status by duration.
PBI:
In the source data, I have converted each field from milliseconds to duration using the following custom column.
And ensured the format is in time format
What I am getting:
I'm assuming it's possible, but it's obviously not quite as simple as my brain would like.
Any help here would be amazing! Sorry, I'm unable to share data.
Thanks so much
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
2 Replies
- amitchandak
Super User
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
Auskiamitchandak 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!!