Forum Discussion
Format Function - Decimal (Dot or Comma)
Hi Everyone,
Im having issues using the Format Function. The left columm is a regular setup using the options from powerbi, right column is me trying to use the format function but no matter what i do it gives me "." instead of "," . All my settings are in english (USA)
3 Replies
hi, Anonymous
I have tested by your formula, but not reproduce the issue.
This is your formula
Your = SWITCH(TRUE(),[Selected Currency]="USD",FORMAT([Turnover]/VALUES(Table2[Currency Rate]),"$0,00"),[Turnover])
and You could try this format
MY = SWITCH(TRUE(),[Selected Currency]="USD",FORMAT([Turnover]/VALUES(Table2[Currency Rate]),"$#,##0.00"),[Turnover])
If not your case, please share your sample pbix file, just need a little sample data.Do mask sensitive data before uploading
Best Regards,
Lin
HI, Anonymous
please update the latest version power bi desktop ( 2.65.5313.841 ) then try it again.
You may also try to change region setting as these similar posts:
https://community.powerbi.com/t5/Desktop/Thousand-Separator-and-Decimal-Separator/td-p/194928
https://community.powerbi.com/t5/Desktop/change-format-by-using-dot-instead-of-comma/td-p/372348
If not your case, please upload sample pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
