Forum Discussion
How to achieve such format?
- 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
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