Forum Discussion
Anonymous
4 years agoNot applicable
How to achieve such format?
Hello, Currently my decimal number is displayed as 4 700,00. I would like it to be 4.7000,00 or 4.700 if I get rid of decimal places. How it is achieveable?
- 4 years ago
Hi, Anonymous
You can try following steps to transform data
1.Click 'Transform Data' and change the column type to 'Text'
2. Replace character' ' with character '.' and replace character ',' with character ''
3.Change the column type to 'Decimal Number' and click 'Close & Apply'
4.Then you can use custom format strings in Power BI Desktop to customize how fields appear in visuals
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Best Regards,
Community Support Team _ Eason
amitchandak
Super User
4 years agoAnonymous , this usually controlled by regional setting at Desktop or Power bi service level
Anonymous
4 years agoNot applicable
Hi,
Can you describe how? Isnt the number format only related to power bi desktop?