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.
Helle all,
Thanks to this blogpost I have found a sulution for this problem without changing the locale for the whole Power Bi file. The steps are:
- Go to the Power Query-editor and select the column
- Change the data type to "decimal number" in the transform menu
- Open the advanced editor and add the desired locale string to the "Table.TransformColumnTypes" function.
Example:
#"Type gewijzigd" = Table.TransformColumnTypes(#"Kolommen verwijderd",{{"sales.grand_total_month", type number}}, "en-US")
This is the right answer. I don't care about Regional Display, I want the Power Query to correctly parse my column as it is written.
