Show minutes as duration/time

[Ramadhianto]

Hi All,

I have an issue in which i have a column containing minutes value originally representing duration stores as whole number (i.e. 3312 minutes, 1200 minutes, etc)

1. i need to divide these by number of user to have average duration per user (i.e. 3312 minutes divided by 10 user equal 331.2 minutes) : done using DAX

2. i need to show these in line chart

step 2 is where im stopped at. In Excel (also using powerquery for compiling), i simply create a calculated field of [Minutes] divided by 1440 (which will convert these to minutes in decimal where 1 = 24:00:00 as used in excel) an put it in the chart. After formatting the calculated field as [h]:mm it will show properly (example : 331.2 minutes divided by 1440 equals 0.23, in which if formatted as [h]:mm will show properly as 5:31)

how can i do this in PowerBI? i tried to convert it to duration in powerQuery (and it showed up properly as duration in query preview), but somehow get recognized as text when in powerBI. as this far, i only end up having these as decimal (but cannot convert it to duration/time display)

there is a method which involved converting using FORMAT([Duration], "h:mm") but then it will throw error when used in line chart

currently im at these :

and these are the output im looking for (from excel pivot). 

Thank you

Rgds,

D

[v-yuezhe-msft · Accepted solution]

@Ramadhianto,

Power Query has duration data type, but Power BI Reports don't have the duration data type, regarding to this issue, please vote up this idea. Thus we are not able to display the Duration on the Y-Axis in HH : MM format, however, we can use R visual as a workaround.

For more details, please review the similar thread below.
https://community.powerbi.com/t5/Desktop/Show-measure-HH-MM-SS-in-y-axis/m-p/241155

Regards,
Lydia

[Ramadhianto]

Voted that idea too.. guess need to do it in R visual then 😄

Thank you