- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-19-2017 07:24 AM

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?

Solved! Go to Solution.

Accepted Solutions

## Re: Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-20-2017 02:02 AM

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

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*All Replies

## Re: Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-19-2017 07:51 AM

Is this what you are after? It appears you can conditionally format your matrix via negative numbers to any color with the March version of Power BI.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/

## Re: Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-19-2017 08:47 AM

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)**

## Re: Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-20-2017 02:02 AM

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

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-26-2018 03:31 AM

TRy,

= Format([Measure],"#,##.#0;(#,##.#0)")

## Re: Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-19-2018 02:28 AM

You can use the DAX *Format* function to format negative numbers with enclosing brackets. However, the result is a text value. You can use conditional formatting to make negative **numbers** show as red (but not **text values**). So…

If you can live with a negative sign and red, it’s easy, just use the conditional formatting (see screen shot below).

If you must have brackets and red, my somewhat involved solution:

- Create a new measure to add the brackets for the negative numbers: For example,

Total Including Tax Formatted = FORMAT([Sum of Total Incl Tax],"#,##.#0;(#,##.#0)") - Apply the red-if-less-than-zero conditional formatting to the formatted measure. Because the result of the
*Format*function is text, you can’t use the value of the formatted measure to determine if it’s less than zero. Instead, use the value of the*original*measure (Sum of Total Incl Tax in the screen shot below) to add the red to the formatted measure when negative. You don’t need to include the original measure in the visual, but it must be in the table. Also, being text, the formatted measure aligns to the left, and I can’t see how that can be changed.

## Re: Format negative numbers in red parenthesis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

10-29-2018 06:12 AM

Hi,

I was following your example and it did work. Thank you!

One question though, looking at your screenshot, it looks as if you were able to summarize the formatted column although it is TEXT and you also mentioned that in your instruction.

How were you able to do a summation on a TEXT format column.

Thanks!

NH