How to display numbers in accounting terms but not show any currency symbol next to them

[Anonymous]

Hello All,

I am creating an accounting report in PowerBI. Need help n showing the numbers (negative or positive) as they are. Wherever the numbers are negative I want to show the numbers in paranthesis, which I have figured out how to do.

But where I am stuck is on how to not show the currency symbols. By default the currency general option shows up $ symbol. Since my data has numbers from 5 different currencies, how can I overcome this issue?

Any help on this would be highly appreciated.

[Ani1991 · Accepted solution]

@Anonymoushope this post is helpful.
Else it would be more helpful if you kindly provide some sample data.

Also try this,

Column = FORMAT(table[origcolumn];"#,##0.00;(#,##0.00)")

Thanks,

Ani