How to format negative numbers in red parenthesis in Power BI Desktop

Question

Hi,

I have created a table in Power BI Desktop with the help of raw data available. Its uploaded to PBI and also created a table/matrix.

I need to show all the negative values in red parenthesis and I am not able to do so. Is there any procedure for the same??

Answer 1

As per the latest update of Power BI, there is no such option to format the negative value and to keep the number data type at the same time. However, you can create a calculated column to return the format. But in this case, the result will be treated as TEXT instead of a number.

Formula:

Column = IF('Table2'[Column1]<0,"(" & FORMAT('Table2'[Column1],"General Number") & ")" ,FORMAT('Table2'[Column1],"General Number"))

Hope This Helps!!

Answer 2

Hi Phalguni, 

Thanks for your question. It used to be more difficult. One would have to use the FORMAT function. Nowadays we can simply use a custom formatting for a measure. Something like this could work: "#,##0.0, (#.##0.0)". Hope that helps. If you would like to read more also check out: 

https://excelgorilla.com/power-bi/display-negative-numbers-between-parentheses/

Keep crushing it!

Rick