Format Function - Decimal (Dot or Comma)

[Anonymous]

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)

[v-lili6-msft]

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

[Anonymous]

Hi Lin,

thanks for taking the time to help me,  i run your formula and the error persist. This are my settings, maybe the OS config is the one giving the trouble?

how can i send you the sample?

[v-lili6-msft]

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