Comma points in currency value

[Anonymous]

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?

[v-diye-msft · Accepted solution]

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.

[Anonymous]

Amigo, não funcionou.

It didn't work buddy, look below

[v-diye-msft]

Hi @Anonymous 

Did you try my suggestion?

[Tahreem24]

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.

[parry2k]

@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

[Anonymous]

It didn't work buddy, look below

---

It didn't work buddy, look below