Combining multiple excel and aggregate by category.

Hi, Anonymous ;

Is your duration displayed in PowerBI in the same hh: MM: SS format as in the picture?

If so, it is in text form, so the calculation result is incorrect and count of chart. You could check the Issues forum here:

https://stackoverflow.com/questions/62989953/how-to-find-total-duration-of-time-in-power-bi

https://stackoverflow.com/questions/52054319/show-time-duration-as-hhmmss-in-powerbi-charts

and can you share  a simple data removing sensitive information, along with the results you want to output?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.