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: ...
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,
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.
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.