Average Time Visualization

[Amine]

Dear All,

I'm tryning to find the way to get a report that allow me te see the average of time data.

This my data :

This is My expectation from Power BI but done with excel :

In Power BI, I'm not able to see the Time value. 

Many thanks for you Help

BR,

[Greg_Deckler]

See my blog article here:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

Basically, you will need to convert it to seconds, there is no true duration type in Power BI. But you can vote for the Idea here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type

[v-ljerr-msft]

Hi @Amine,

As smoupre mentioned above, there is no true duration type in Power BI currently. You can vote the idea and add your comments there to improve Power BI and make this feature coming sooner.

Regards