Hi Friends
I have a problem with time format in PBI , i want to demonstrate the over time in column chart , but instead of suming the values for different people , it counts them !!!
in the edit queries i ve changed the overtime format to TIME , but still doesnt work and also there is no Sum in quick calc too .
i ll be so thankful if u help me on this
It is relatively hard to do aggregations on TIME FORMATS of the data. For this purpose, I have split the column by " : " Delimiter and
then again split by space demiliter to remove AM. Followed by this, I multiplied the hour column by 60 and summed up hour and minutes column together to get total minutes.
It is then divided by 60 and rounded to 4 decimal places to get the actual overtime in hours.
All I have done this in Query Editor and You can finally see the results in the column chart summed up.
REFER TO THE SCREENSHOTS ATTACHED FOR THE STEPS.
It is relatively hard to do aggregations on TIME FORMATS of the data. For this purpose, I have split the column by " : " Delimiter and
then again split by space demiliter to remove AM. Followed by this, I multiplied the hour column by 60 and summed up hour and minutes column together to get total minutes.
It is then divided by 60 and rounded to 4 decimal places to get the actual overtime in hours.
All I have done this in Query Editor and You can finally see the results in the column chart summed up.
REFER TO THE SCREENSHOTS ATTACHED FOR THE STEPS.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
