How to get number in German format

[Anonymous]

Hi,

I'm pulling sales data from PostgreSQL to Power BI. The numeric values should appear in German format in Power BI.
For example:  1.0 should come as 1,0 and 19,999.61 should come as 19.999,61.
I changed the Locale Import to German (Germany) in regional settings and changed the data type to decimal (German) using Locale in Power Query Editor. Still it is not reflecting. I can format it by changing the data type to text. But need this data as decimal for all the calculations.

Can anyone help me how to do it? 

[Anonymous]

Here is my input data:

I changed the data type to German

Changed Locale for import to German (Germany).

Still getting the same format.

It should have been

1,20 €

123,45 €

19.099,45 €

11.111.111,23 €
I have tried this and also changed the number format in my system. Still no change in the data format in Power BI.

[rajendraongole1]

Hi @Anonymous -Please follow the below format changes in power query editor and regional setting in power bi desktop application

In Power query editor select the numeric column that you want to change Locale of Data Type:
Select the column(s) with your numeric values>>On the ribbon, under Transform tab, click on Data Type (where it shows Decimal, Whole Number, etc.).
Choose Using Locale>>In the dialog box that appears, select Decimal Number for Data Type and set the Locale to German (Germany)>>Apply Changes: Once you've set the correct locale, click "Close & Apply" to apply the changes to your data model.

Step 2: Change Regional Settings for the Report
Go to File > Options and Settings > Options.
Under Current File, select Regional Settings.
Set the Locale to German (Germany).

Apply the changes and refresh the data.

Final output:

Hope this helps.

[Anonymous]

I have tried this. attached the screenshot above. Still not getting the data in the required format.

[Anonymous · Accepted solution]

Thanks for the reply from @rajendraongole1 , please allow me to provide another insight.
Hi @Anonymous ,

Accroding to the Microsoft documentation.
Supported languages and countries/regions for Power BI - Power BI | Microsoft Learn
Power BI Desktop gets its default number and date formatting from the Windows Region settings.
You need to make the following settings in Windows Regional Settings.

In this way, the numbers are displayed in the German format.

However this will cause other data such as numbers in Excel to be displayed in the German format as well.

Therefore, if you don't want to fulfill your needs by changing the Windows regional settings, then I'm afraid you'll have to format it by changing the data type to text.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for the solution. It really worked. We also changed the region in Power BI Service to Germany and it worked.