Duration as Y-Axis Label

[Anonymous]

Hi, All,

I have a two-column table: "Date", and "Average Length of Call in Seconds".

I need to create a visualization showing Date along the X-Axis, and Duration along the Y-Axis.

Easy enough, but I need the Y-Axis to be formatted as MM:SS instead of a whole number (for example "05:02" instead of "302").

I've searched through the Forums, and the Community Blog and see several threads about duration, but haven't been able to achieve my desired result.

Thanks, in advance, for any help!

--Michael--

[v-haibl-msft · Accepted solution]

@Anonymous

We can have the duration column in Table chart displayed as MM : SS with type Text, but cannot display it in some visuals like Bar or Column chart.

If we drag Text data into Values in Bar or Column chart. They will be converted to Count because they are non-numeric type.

I think you can vote this idea here.

Best Regards,

Herbert

[ankitpatira]

@Anonymous change the column type as Text and use that.