format negative numbers in paranthesis from a measure

[mikebi]

Hello,

What is the best way to format a measure to show the negative numbers in paranthesis, negative 100 is (100).

This is my model.

Thank You,

Michael

[johnbasha33 · Accepted solution]

@mikebi  please use this, it will do the job.
Formatted Sales = IF([Total Sales] < 0, "(" & FORMAT(ABS([Total Sales]), "#,##0.00") & ")", FORMAT([Total Sales], "#,##0.00"))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Greg_Deckler]

@mikebi Use this as your custom format string:

#,0.###############;(#,0.###############);#,0.###############

[mikebi]

Hello, 

Where can I define the Custom Format String in Power BI?

Thank You,

Michael

[Greg_Deckler · Accepted solution]

@mikebi So, Dynamic format strings for measures are a preview feature that you have to turn on. Once you turn them on you can go here and choose Dynamic and paste in the format string I provided.

The problem with doing it using FORMAT is that you turn the number into text and that is often a very bad thing if you are trying to plot the number in a line graph for example. But, if you are just displaying it in a table or matrix then it might not be so bad.

[johnbasha33 · Accepted solution]

@mikebi  please use this, it will do the job.
Formatted Sales = IF([Total Sales] < 0, "(" & FORMAT(ABS([Total Sales]), "#,##0.00") & ")", FORMAT([Total Sales], "#,##0.00"))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!