Number.ToText stopped working for HEX?

[Anonymous]

This was never a problem until a week or two ago?
This worked perfectly for months and months, now it doesn't work all of a sudden.
The syntax is absolutely straight forward too.

Any ideas?

[v-yanjiang-msft]

Hi @Anonymous ,

It works fine in my side.

Please try to reinstall the latest version:

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best regards,

Community Support Team_yanjiang

[Anonymous]

This is online in the dataflow editor.

[v-yanjiang-msft]

Hi @Anonymous ,

I also tried that in a dataflow, get the correct result in my side.

Not sure why you have a step "Table.TransformColumnTypes", try to simply creat a custom column like below.

=Number.ToText([Column1], "x")

Best regards,

Community Support Team_yanjiang