Convert Work Time from Decimal to HH:MM:SS while preserving summarization capabilities (Paginated)

[RYU209]

Hello,

Currently I have employee work time data in a decimal format - e.g. 2.57 hours worked.

Is there a way to convert this to a HH:MM:SS format while also preserving the ability to sum the values up? I have created formulas to convert the time to HH:MM:SS but it involves concatenating text strings and cannot be summed up when used in a matrix in a paginated report. 

For instance, I have a matrix in Power BI Report Builder that shows the following when collapsed:

When expanded, some of the data looks like this:

Notice how the collapsed version is showing 04:13:48 (first entry in the expanded version) and not the actual sum of all the time. 

Is there a way to accomplish what I need here? 

[Greg_Deckler]

@RYU209 Hmm... If this was Power BI Desktop the answer is custom format strings. Not sure if there is anything equivalent in paginated. Not sure if this solution is an option but see this thread: datetime - Formatting Seconds into Days, Hours, Minutes, Seconds for SQL Report Builder Y-Axis Label...

[RYU209]

Hi @Greg_Deckler ,

Thanks for the response - I will see if the link you sent is applicable for my purposes. 

I'm actually using a Power BI Dataset as the source for my Paginated report and many of the fields in the matrix are Power BI measures I created in Desktop so maybe custom format strings could work? Do you mind going into more detail? 

[Greg_Deckler]

@RYU209 Sure, here's the detail: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639...