Unable to sum time column with slicer

[yasirhasnain]

Unable to sum time column, I want to sum time field in "HH:mm" format in Pie chart to show overtime hours of employees by designation/department. Also, I want to use slicer to view data for particular period.

[V-lianl-msft · Accepted solution]

Hi @yasirhasnain ,

Please refer to these thread:

https://community.powerbi.com/t5/Desktop/Sum-of-H-MM-SS/td-p/124007 

https://community.powerbi.com/t5/Desktop/How-to-do-sum-of-multiple-time-column-HH-MM-SS-in-Power-BI/... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

don't use Time field type, use Duration.