format negative percentage with bracket and in red

[Anonymous]

Hi Experts

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

[v-yetao1-msft · Accepted solution]

Hi @Anonymous 

(1)You need change the data type of the value to text in Power Query .

(2)Then create a column to add “()” for the value .

(percentage) = FORMAT("(" & SELECTEDVALUE('Table'[Column1]) &")","")

(3)Configure conditional formatting for the value .Choose the column[(percentage)] in fields ,and select Gradient in Format style .

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regard

Community Support Team _ Ailsa Tao

[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