Forum Discussion
Can't use SQL TIME as Duration
There is further detail on issues with Duration data type in Power BI on this thread, http://community.powerbi.com/t5/Desktop/Format-the-average-of-a-duration/m-p/95816#M40368
It includes a DAX function to display a decimal version of a Power Query Duration data type in D.HH:MM:SS format. That might be extended for what you need but is restricted for use as text display only, not a numeric measure on charts etc.
The solution is that this is not supported and you should vote for a proper feature here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type
In the meantime, I will add two columns one as text for the table and one as decimal for the graph.
There is further detail on issues with Duration data type in Power BI on this thread, http://community.powerbi.com/t5/Desktop/Format-the-average-of-a-duration/m-p/95816#M40368
It includes a DAX function to display a decimal version of a Power Query Duration data type in D.HH:MM:SS format. That might be extended for what you need but is restricted for use as text display only, not a numeric measure on charts etc.
The solution is that this is not supported and you should vote for a proper feature here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type
In the meantime, I will add two columns one as text for the table and one as decimal for the graph.