Forum Discussion
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
for example - powerbi shows 121,000.00 (thousand separator is a comma and Decimal separator is a point)
Output expected, 121.000,00 (Decimal separator is a comma and thousand separator is a point)
Thanks
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.
