Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 ?
Solved! Go to Solution.
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
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
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.
yes i need help. Could u help me ?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!