cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amine Occasional Visitor
Occasional Visitor

Average Time Visualization

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 :

 

 

 

 

Capture1.PNG

 

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

Capture 2.PNG

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

 

 

Capture 3.PNG

 

Many thanks for you Help

BR,

2 REPLIES 2
Super User IV
Super User IV

Re: Average Time Visualization

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

 

 

 

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Microsoft v-ljerr-msft
Microsoft

Re: Average Time Visualization

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.Smiley Happy

 

Regards

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors