Forum Discussion
RacAgr
Helper I
Helper IThousand-Separator-and-Decimal-Separator
hello, for the currency column, I'm having problems with decimal separator and thousand separator. Decimal separator is a comma and thousand separator is a point. But PowerBi goes wrong f...
The display of numeric felds (and dates, times etecetera) depends on your Regional Settings.
It can be adjusted in Power BI Desktop or in Windows (Land/Region). It looks like the Windows setting is leading, but you have to close and reopen your pbix file after adjusting the Regional Settings.
In Power BI you can also adjust your language settings to influence the display format for published reports.
Formatted Sales =
FORMAT(
[Your Measure or Column Name],
"Currency",
"nl-NL"
)