Hello all, I had in my PBIX American regional seetings so the format that i am showing the amounts is this one 12,000.55 so comma for thousands seperator and dot for decimals. I want to show it in European format so 12.000,55 dot for thousands seperator and comma for decimals. I tried a lot of ways like this FORMAT(BALANCE_DEF_CURR, "#0.000") but nothing worked. I changed the regional seetings to Greek but again the same. Does anybody know how to do it ?

Dear devesh_gupta thanks for your answer but i do not want to show it as currency. I just want to show the amount (pure number) in this Format ##.###,##. Either i change it for the modeling tab or from dax code it doesn't change.

devesh_gupta Where is the Decimal and Thousand seperator dropdown ? Do i miss something ?

Actually i want the opposite #,##0.00. i.e this one #.##0,00 but this doesn't work.

pbi1908 To change the number format in Power BI Desktop from American format (comma for thousands separator and dot for decimals) to European format (dot for thousands separator and comma for decimals), you can follow these steps:Select the field or column that contains the amounts you want to format.In the Fields pane, click on the Modeling tab.In the Properties group, click on the Format dropdown list.Select the desired format for your amounts. For example, you can choose Currency, then select the appropriate currency symbol and decimal places.Click outside the dropdown list to apply the format.By following these steps, you can change the number format to European style in Power BI Desktop. If you find this insightful, please provide a Kudo and accept this as a solution.

pbi1908 Then, you can follow these steps:Select the field or column that contains the amounts you want to format.In the Fields pane, click on the Modeling tab.In the Properties group, click on the Format dropdown list.Select Decimal Number from the list.In the Decimal places dropdown list, select the desired number of decimal places.In the Thousands separator dropdown list, select Dot.In the Decimal separator dropdown list, select Comma.Click outside the dropdown list to apply the format.By following these steps, you can change the number format to European style without currency symbols in Power BI Desktop.If you find this insightful, please provide a Kudo and accept this as a solution.

Show an amount in European format | Microsoft Fabric Community

12 Replies

devesh_gupta
Impactful Individual
2 years ago
pbi1908
To change the number format in Power BI Desktop from American format (comma for thousands separator and dot for decimals) to European format (dot for thousands separator and comma for decimals), you can follow these steps:
Select the field or column that contains the amounts you want to format.
In the Fields pane, click on the Modeling tab.
In the Properties group, click on the Format dropdown list.
Select the desired format for your amounts. For example, you can choose Currency, then select the appropriate currency symbol and decimal places.
Click outside the dropdown list to apply the format.
By following these steps, you can change the number format to European style in Power BI Desktop.

If you find this insightful, please provide a Kudo and accept this as a solution.
- pbi1908
  Helper III
  2 years ago
  Dear devesh_gupta thanks for your answer but i do not want to show it as currency. I just want to show the amount (pure number) in this Format ##.###,##. Either i change it for the modeling tab or from dax code it doesn't change.
  - devesh_gupta
    Impactful Individual
    2 years ago
    pbi1908 Then, you can follow these steps:
    Select the field or column that contains the amounts you want to format.
    In the Fields pane, click on the Modeling tab.
    In the Properties group, click on the Format dropdown list.
    Select Decimal Number from the list.
    In the Decimal places dropdown list, select the desired number of decimal places.
    In the Thousands separator dropdown list, select Dot.
    In the Decimal separator dropdown list, select Comma.
    Click outside the dropdown list to apply the format.
    By following these steps, you can change the number format to European style without currency symbols in Power BI Desktop.
    
    If you find this insightful, please provide a Kudo and accept this as a solution.
Khushboobarai
Helper IV
7 months ago
Hii,Can someone pls help me with my sales column which I imported form the excel, and in that rwa file it was just in General format, but in power bi, i want it to convert into european decimal value , in my case i have tried changing the regional setting as German(germany) and even treid in the power query to change my data type using local and then german(germany), Then in power bi i tried changing with the currency too but what happens is it gave me only euro sign.
Only Euro sign but no change is the decimal or thousand seprator
as from the ss

1st value supposed to be 1.000.000,00 but it gave as in Indian format pls help