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
336 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 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
• 41,460 points
252 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
92 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
• 27,880 points
37 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 27,880 points
183 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
• 41,460 points
43 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
• 41,460 points
79 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
• 41,460 points
57 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
101 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
37 views