Column format change not applying

[Victormar]

Hi all,

So I am getting time duration from a sharepoint list in fractions of days, and when loading into power bi using power query I can transform it to "duration" but then this change doesn't apply when working with the data:

Power query:

But when applying the changes:

Data type is still decimal: 

I know I can extract the data I want as text, but don't understand why this is happening.

Thanks in advance 🙂

[Victormar]

Thanks to both, and sorry for the late reply. They changed my pc and was setting everything up.

Many thanks!

[Anonymous · Accepted solution]

Hi  @Victormar ,

I'm afraid you'll have to convert it to text since, as far as I know, Power BI doesn't yet handle fractions of a second in time format.

The decimal representation you have is in days. Taking that into account, you can convert it to the format you show (text) in a calculated column:

NewColumn =
TRUNC(Table4[Zeit2 - Copy]) & "." &  //Days
FORMAT(TRUNC(Table4[Zeit2 - Copy]*24);"00") & ":" &//Hours 
FORMAT(TRUNC(Table4[Zeit2 - Copy]*24*60);"00") &  ":" & //Minutes
FORMAT(Table4[Zeit2 - Copy]*24*60*60;"00.0000000") //Seconds

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Victormar , In Dax you have Time, not duration. Can you manually Change it text and check