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 in Power BI by Phalguni
• 1,010 points
706 views

1 answer 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 by Avantika
• 1,500 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 in Power BI by anonymous
• 32,260 points
17 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 45,780 points
319 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27 in Power BI by Phalguni
• 1,010 points
134 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28 in Power BI by Cherukuri
• 32,260 points
45 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
• 45,780 points
53 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
• 45,780 points
86 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
• 45,780 points
70 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 in Power BI by Avantika
• 1,500 points
308 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 in Power BI by Avantika
• 1,500 points
46 views