Format string thousands Value issue

[Anonymous]

Hello,

I work with a tabular model and i create a new measure with the format string as bellow : 

#,##0,.00 K

When create a matrix in power bi and i display the measure i have :

4,456,180.13 K  (which I expect)

But when i change the value decimal places to 0 on the property of visual 

the measure value change to : 4,456,180,133  K (which I do not expect, I hoped for 4,456,180 k)

Is there a solution to this? or is this a bug?

[Anonymous · Accepted solution]

Hi @Anonymous ,

After using Format, the data type becomes a text type.

https://docs.microsoft.com/en-us/dax/format-function-dax

You can modify dax to the following form:

Measure = FORMAT(MAX('Table'[amount]),"#,##0,K")

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.