DIsplaying call center Time Duration in line graph

Anonymous · ‎09-20-2022

Hi,
I have a call center Data to be disaplyed in line graph. The duration of a call should be in MM:SS format.
In line graph i need to show the duration.

The Existing report is in Excel format and in EXCEL we have mm:ss data type but in power bi it is not available.
I have used the following DAX to get minutes:Seconds from time

mm:ss = format([Date], "nn:ss")

but there is no datatype for minutes:seconds format so i assgined text format as a datatype. But i couldnt assign text column in line graph y axis.

Please suggest how to display mm:ss in line graph y axis in power bi?

Greg_Deckler · ‎09-20-2022

@Anonymous Chelsie Eiden's Duration - Microsoft Power BI Community

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎09-20-2022

Hi @Greg_Deckler Thank you for your reply. Yes i have tried the measure you have mentioned. But that also we are setting as text.

I need some guidance for the below line you in the suggested post,
Once you have this measure, then all you have to do is implement Chelsie Eiden's Custom Format String with a value of "00:00:00" (no double quotes). Boom!!

I couldnt change the datatype to decimal as mentioned, and format i tried to set as custom but it is not allowing me to set as custom automatically it changes to general.

Please advice how to set the datatype in the mm:ss format