Format string thousands Value issue

Anonymous — Wed, 09 Mar 2022 15:52:12 GMT

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?

Re: Format string thousands Value issue

Anonymous — Mon, 14 Mar 2022 03:07:55 GMT

Hi Anonymous ,

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

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.