How to achieve such format?

[Anonymous]

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?

[v-easonf-msft · Accepted solution]

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]

@Anonymous , this usually controlled by regional setting at Desktop or Power bi service level

[Anonymous]

Hi,

Can you describe how? Isnt the number format only related to power bi desktop?