Format Cell Value without k,m,b

[ys034]

Hi,

is there any possibility to change the Value from 31,0K to 31,0 it should not show me the k

i have tried to change it via this format section but i can't get to the solutio.

Is there any trick?

[MFelix · Accepted solution]

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)

[v-zhangti · Accepted solution]

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.

[MFelix · Accepted solution]

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)

[ys034]

Thank you!!! both workarounds works for me