Forum Discussion
Format Cell Value without k,m,b
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?
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.
3 Replies
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)Thank you!!! both workarounds works for me
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.
