Need Help plotting stack graph with seconds converted into Hrs per week.

Question

Hello - i have data in seconds format - which is in whole number. How to i convert it in to Hrs and show it in stacked bar graph by weeks. I have perday data by seconds which i have sorted in weeks.

i currenlty used below to convert to Hrs but i am not able to graph it. below is in Text format output.

HH:MM TotalTime =

VAR TotalSeconds = SUM(Merge1[Total Time]) // Replace 'YourTableName' with the name of your table

VAR Hours = INT(TotalSeconds / 3600)

VAR Minutes = INT(MOD(TotalSeconds - (Hours * 3600), 3600) / 60)

RETURN

FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00")

anonymous · Answer

Hi&nbsp;masifmalik&nbsp;,Based on the information you provided, the measure you wrote will convert seconds to HH:MM text format, which is not ideal for creating stacked bars.You can add the measure in Value:
&nbsp;
&nbsp;

&nbsp;
Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
&nbsp;
Best Regards,
Ada Wang
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Need Help plotting stack graph with seconds converted into Hrs per week.

1 Reply

Related content

Convert Seconds to DD:HH:MM:SS

How to convert seconds to hh:mm:ss

Convert Days, Hours, Minutes and seconds in to Seconds

How to convert seconds to hh:mm:ss

Convert HH:MM:SS to seconds