Forum Discussion

Miskondukt's avatar
Miskondukt
Icon for Helper III rankHelper III
9 years ago
Solved

Format negative numbers in red parenthesis

Good Morning, I have a table I have uploaded to PBI and when creating a table/matrix I would prefer to have negative values viewed in red parenthesis. Is this option available?
Tips and Tricks
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Miskondukt,

     

    Currently, there is no OOTB option for us to format the negative number as (value) and keep the number data type at the same time. We can only create a calculated column below to return (value) format but the result will be treated as TEXT instead of number, and Conditional Formatting is not available.

     

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

     

    For your requirement, you can submit a idea here.

     

    Best Regards,
    Qiuyun Yu

Rickmaurinus's avatar
Rickmaurinus
Icon for Helper V rankHelper V
6 years ago

Hi

, 

Formatting negative numbers in parentheses is great to differentiate positive and negative in for example financial reporting, so good question. And it used to be quite difficult in Power BI before. You would have to use the FORMAT function. Not only would this change the formatting, but also turn a measure into text. So aggregation would be difficult. But today you can simply use custom formatting for a measure. Try custom formatting: "#,##0.0, (#.##0.0)". You can find more details on this here: 

 

Display Negative Numbers between Parentheses 

 

Keep crushing it!

Rick

 

--------------------------------------------------

@ me in replies or I'll lose your thread

 

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.