Solved: Calculate sum time per categores

Bennasy23 · ‎08-09-2021

Hello in data table i have column "Time spent" column format is "Time (hh:mm:ss).

When i add "Time spent" in chart, in value, i cant sum, average and so on...

It is possible sum time in POWER BI ?

v-shex-msft · ‎08-10-2021

AFAIK, common charts will display the summarized values based on the current category(axis, legend). (For date/time type values, they can't able to be aggregated.)
Perhaps you can try to convert your duration to total second format then you can simply use them on chart value fields.

Aggregating Duration/Time - Microsoft Power BI Community
Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

v-shex-msft · ‎08-10-2021

Hi @Bennasy23,

AFAIK, common charts will display the summarized values based on the current category(axis, legend). (For date/time type values, they can't able to be aggregated.)
Perhaps you can try to convert your duration to total second format then you can simply use them on chart value fields.

Aggregating Duration/Time - Microsoft Power BI Community
Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

selimovd · ‎08-09-2021

Hey @Bennasy23 ,

in general you can't sum values with the format time directly.

You have to do a workaround. For example to calculate everything in seconds, then you can sum them up. Then you have to change the display in hh:mm:ss with a DAX measure.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic