Show negative numbers as red and in bracket

[Anonymous]

Hi Experts

In the model and Properties pane how - what could i add to show my percentages as (23).

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, here’s my solution.

1.Create a new calculate column.

Column2 = FORMAT('Table'[Column1],"#,##0;(#,##0)")

2.Conditional formatting for column2 like Tahreem24 mentioned.

Put column2 in a visual, select Format--Conditional formatting--front color, and apply the color rule with the value of column1.

3.Get the expected result.

Best Regards,
Community Support Team _ kalyj

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

[Tahreem24]

@Anonymous  Try this out:

Step1 : Select your numeric column in my case I called it "Profit". Go to Column Tool menu and Select "$" sign like below:

Step 2:  It will appear in a table like below:

Step3: Go to Table property field under Visualization pane >> Click on small down arrow of Profit column >> Conditional Formatting >> Font Color 

Step 4: Do the below setting

Step 5: Then you'll see the required output.

[amitchandak]

@Anonymous , Refer

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=7fa2bb16-9c56-4a17-910a-9794d2f13159&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-conditionally-formatting-brackets-with-negatives