HiI have value in a column, i didn't arrive to format it like this :Ex Value :1234.45 => 1 2341223445,45 => 1 223 45A space between block and whitout decimal ThanksNicolas

Hi nicolast29 you have to apply this as custom format string in the model properties like so: # ##0

Forum Discussion

Helper V

3 years ago

Solved

I have value in a column, i didn't arrive to format it like this :

Ex Value :

1234.45 => 1 234

1223445,45 => 1 223 45

A space between block and whitout decimal

Thanks

Nicolas

ImkeF
3 years ago
Hi nicolast29
you have to apply this as custom format string in the model properties like so: # ##0

ImkeF
Community Champion
3 years ago
Hi nicolast29
you have to apply this as custom format string in the model properties like so: # ##0
- nicolast29
  Helper V
  3 years ago
  Sorry after slipping i forgot to say in Excel and not in Power BI
ImkeF
Community Champion
3 years ago
Hi nicolast29 ,
this should work as a custom format string in Excel as well.