Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
3 years ago
Solved

Format value currency without decimal (Excel side not Power Bi)

Hi 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
Need Help
Show and Tell
  • ImkeF's avatar
    ImkeF
    3 years ago

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

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

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

 

  • nicolast29's avatar
    nicolast29
    Icon for Helper V rankHelper V
    3 years ago

    Sorry after slipping i forgot to say in Excel and not in Power BI