Format Cell Value without k,m,b

Hi ys034 ,

This is related with the card options that you cannot change directly. In this case the better option is to create a measure that get's the value on thousand and then, you need to go to the card settings and then select the callout value and select none instead of auto:

ThousandValue =DIVIDE( SUM(Table[Value]), 1000)

Hi, ys034 

You can try the following methods.

Column:

Column = FORMAT([Value], "#,##0")  

Column 2 = FIND(",",[Column])

Column 3 = LEFT([Column],[Column 2]-1)

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.