Stacked Bar Chart with Duration

[Auski]

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

[amitchandak · Accepted solution]

@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]

@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!!