Forum Discussion
Format string thousands Value issue
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?
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.
1 Reply
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.