Forum Discussion
Comma points in currency value
Hi all, I need to leave my currency value in the same format as the American, it is not the question of the symbol "R $ - US $", but about the punctuation (commas and points) In Brazil, for example: 1.442.332,99 In the USA 1,442,332.99 I need to leave like USA Does anyone know how I do this?
Hi Anonymous
Please kindly try this feature:
To do this, first select the field in the fields list and select the custom format option in the formatting card of the properties pane.
From there, you’ll be able to select from a list of commonly used format strings.
Or you can use the given an input box to enter in your own format string. Power BI will support most of the VBA style syntax, with a few exceptions. Refer to the full documentation for details.
Once you enter in your custom format string, it will immediately be reflected in the data view and report view.
6 Replies
Anonymous you can use custom format. Here is the link to the doc.
Would appreciate Kudos 🙂 if my solution helped. Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
- Hi,
You wanted to add a thousand separators in your currency column. So just select your currency column and under Modelling menu --> click on ", " comma sign just below Data format option.
Don't forget to give thumbs up 👍 and mark it as a solution if it helped you. Hi Anonymous
Please kindly try this feature:
To do this, first select the field in the fields list and select the custom format option in the formatting card of the properties pane.
From there, you’ll be able to select from a list of commonly used format strings.
Or you can use the given an input box to enter in your own format string. Power BI will support most of the VBA style syntax, with a few exceptions. Refer to the full documentation for details.
Once you enter in your custom format string, it will immediately be reflected in the data view and report view.
Hi Anonymous
Did you try my suggestion?
