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

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

    To a degree, that works; however, it is simply a color formatting based on values shaded on that specific value whereas I am trying to get to any number less than 0 is (red)