Forum Discussion
Helper IThousand-Separator-and-Decimal-Separator
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.
Has something recently changed in this behaviour? I can't seem to get the xxx.xxx,xx formatting using the Locale setting..
I found the solution to my issue; PBI Desktop seems to be only looking at the "Region - Format" part in the Win10 - Control Panel - Clock and Region - Region settings e.g:
Format: Dutch (Netherlands). When customizing this format using the "Additional settings" button, these customizations are not taken into account by PowerBI Desktop; So, it's VERY important to pick the correct Format: selection and not customize an existing selection to the needs of your users.
Created a blogpost around my findings on this.
It works. Important: All figures on data model should have the same type. Be careful when you were transforming data
After several days of trial and error - this fixed it for me!
