Forum Discussion
rbalza
5 years agoHelper III
Format Function using Switch Statement
Hello PowerBi Heroes, Is there a way to remove the decimal point on the format function? I am using switch statement with different measures and formatting. See below measure for reference. Than...
- 5 years ago
rbalza , I think a currency will have a decimal place. choose a format like "###,###"
Refer this page for various format
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Also try to use the property UI, in place of custom format, when possible
amitchandak
5 years agoSuper User
rbalza , I think a currency will have a decimal place. choose a format like "###,###"
Refer this page for various format
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Also try to use the property UI, in place of custom format, when possible