Format trouble

[Anonymous]

Hi,

I recently encountered a problem with a format.

I use a dataset where time spent by date is in seconds (such as : 4424), and to simplify it for the users I used this :
In Dax, for an average duration : TIME(0,0,Average('File1'[Duration]))
And then, in Format : HH:MM

The results were OK for me, as I got values in KPI in this format : 01:52.

Problem is : when I sent the pbix to a colleague, every measure using this format just put HH:MM instead of the values.
All other measures were OK.

Anybody knows where this might come from ?

Best regards,

Martin.

[Anonymous · Accepted solution]

Hi,

The problem comes from the new version :

-In the novembre 2020 version, a format for Hour:Minute was HH:MM

-In the decembre 2020 version, the format is now HH:NN

As a result, a dashboard with HH:MM manually written as format displayed "HH:MM" instead of the values.

Changing it to HH:NN corrected this without further problems.

Best regards,

Martin.

[amitchandak]

@Anonymous , seems really strange. Check what is the format of measure.  Are all numeric measures shown as time now under measure tool.

Ask your colleague, to download the file again and check. Also, make sure both of you are the same version.

[Anonymous]

Hi,

Sorry for the late answer.

Thank you for your help, I will check what you told and update the post with the results.

Best regards,

Martin.