View duration in Power BI stacked column chart instead of count

[Sokkary]

Hi all,

I have the average response duration (mm:ss) for each member in a column and i want to show it in a stacked column chart, legend will be team memebers, it shows the count instead of the actual duration.

A work around i have tried is using the same column as a tooltip but that's not how i want it, i want the length of each stack to represent the duration actually, so the stack representing that a team member usually replies in 3 mins will be smaller than the stack representing that a team member usually replies in 4 mins.

I deleted the team member column for privacy.

Please find the template here.

[Anonymous · Accepted solution]

Hi @Sokkary ,

As you can see, the average response duration is text type.

Text formatting can't show length in a stack chart.

As a workaround, you can convert duration (mm:ss) into seconds (s) to show the length in a numeric data type.

Best Regards,

Stephen Tao

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

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[Sokkary]

Done, can you please check now.