Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DIsplaying call center Time Duration in line graph

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?

 

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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