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

0 votes
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??
Jun 10, 2019 in Power BI by Phalguni
• 1,020 points
4,626 views

2 answers to this question.

0 votes

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!!

answered Jun 10, 2019 by EdurekaUser
• 1,500 points
0 votes

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

answered Jun 10, 2020 by Excel
• 140 points

Related Questions In Power BI

0 votes
1 answer

How to set Automatic page refresh in Power BI Desktop?

1. Click anywhere on the page. 2. Go ...READ MORE

answered Oct 29, 2019 in Power BI by anonymous
• 32,990 points
166 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,930 points
279 views
0 votes
1 answer

How to connect to data in Power BI Desktop

With Power BI Desktop, you can connect ...READ MORE

answered Nov 18, 2020 in Power BI by Gitika
• 65,930 points
126 views
0 votes
1 answer

How to use Dynamic DAX Number Format in power BI?

You can give them the same display ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,930 points
484 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,370 points
256 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,370 points
208 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,370 points
282 views
+1 vote
1 answer
0 votes
1 answer

How do I convert month format in Power BI?

Hi, This can easily be done using DAX ...READ MORE

answered Mar 26, 2019 in Power BI by EdurekaUser
• 1,500 points
3,549 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

answered Apr 10, 2019 in Power BI by EdurekaUser
• 1,500 points
160 views