Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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 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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |