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
7,796 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 Avantika
• 1,520 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 11, 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 30, 2019 in Power BI by anonymous
• 33,030 points
957 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,890 points
1,784 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,890 points
855 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,890 points
2,342 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,360 points
968 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,360 points
847 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,360 points
1,189 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 27, 2019 in Power BI by Avantika
• 1,520 points
4,906 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 Avantika
• 1,520 points
623 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP