Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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?
  • v-easonf-msft's avatar
    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