Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[CFO CFO]

Is there any way to show negative values with parentheses in Power BI without changing it to text?

——————————
CFO CFO
CFO
——————————

[Brent Anderson]

There sure is! 

1. Go to the Model view (where relationships are built and viewed)
2. Select the column that you what to control the format on
3. Expand the Formatting group in the Properties well
4. In the Format drop down, scroll down to the bottom and select Custom
5. That will activate new fields Custom format (to select a built in standard format) and a empty box below that where you can enter formats similar to Excel
   1. I use #,##0.00;(#,##0.00) to get credit values like -1013.50 to display like (1013.50)
6. Now go and check that visual!
7. 

That sound get your interest!

Brent

——————————
Brent Anderson
Business Analysts
Broomfield CO
——————————
——————————————-

[CFO CFO]

Thank you!!! This is perfect.

——————————
CFO CFO
CFO
——————————
——————————————-