Forum Discussion
pbi1908
Helper III
Helper IIIShow an amount in European format
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 sho...
devesh_gupta
Impactful Individual
Impactful Individualpbi1908 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.
pbi1908Helper III
Helper III- 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.
- pbi1908
Actually i want the opposite #,##0.00. i.e this one #.##0,00 but this doesn't work.
- devesh_gupta
pbi1908 In that case, you can raise an issue for this use case:
https://community.powerbi.com/t5/Issues/idb-p/Issues
Thanks.