Forum Discussion
How to get number in German format
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.
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.
Thank you for the solution. It really worked. We also changed the region in Power BI Service to Germany and it worked.