Forum Discussion
Helper IIIShow an amount in European format
Impactful IndividualTo 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.
Helper IIIDear 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
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.- pbi1908
- devesh_gupta
pbi1908 Oh, I appologize for the confusion.
Okay then, can you try like this, if it works:
- In the Properties group, click on the Format dropdown list.
- Select Custom from the list.
- In the Format string textbox, enter #,##0.00.
If somehow this try works, then do let me know.
KhushboobaraiHelper IV
did you know the solution now?