Forum Discussion
Thousand-Separator-and-Decimal-Separator
- 9 years ago
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.
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.
After several days of trial and error - this fixed it for me!