Disable Scientific Notation

[powerKelly]

Hi all,

I am working on building reports for our organization and found that PowerBI is always applying scientific notation to the timestamp column. This is causing an issue when I'm using the DAX functions to convert that timestamp column from a whole number to a date-time string. I confirmed that if I apply the function on a raw number (in the column function) I get the correct HH:mm:ss. However, when I apply it to the column, the HH:mm:ss are off.

I would like to disable the scientific notation to the timestamp column. When I try to force a column type, it continues to tell me that the direct query mode isn't supported and I must convert to an import mode. That wont work for the size of data I'm working with.

Can you help?

Thanks in advanced.

Kelly

[v-shex-msft]

Hi @powerKelly ,

As you said, if you are works on direct query mode. Power bi has limit to modify fields types and use calculated columns. I don't' think you can do custom to turn off scientific notation with these column fields.

Regards,

Xiaoxin Sheng