Forum Discussion
Solved
Unable to sum time column with slicer
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.
Hi yasirhasnain ,
Please refer to these thread:
https://community.powerbi.com/t5/Desktop/Sum-of-H-MM-SS/td-p/124007
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
don't use Time field type, use Duration.
Hi yasirhasnain ,
Please refer to these thread:
https://community.powerbi.com/t5/Desktop/Sum-of-H-MM-SS/td-p/124007
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
