Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

formatting currency with negative value

hi,

is there a way to format a loss or negative currency value to be in bracket & in red color e.g. ($100) ?

 

tls: -nik-

4 REPLIES 4
Anonymous
Not applicable

Hi, 

 

Have you found the solution yet?.

If not, here is a solution for you. You can change the -100 into (100) for any currency as per below format.

To change it red, just use conditional formatting and use Rules

 

tutorial.png

 

If your found this heplful, please vote..thanks.

Anonymous
Not applicable

Hi,

 

You would try to do this with a Measure

Measure:= IF (SUM(Value) <0, "("&LEFT(SUM(Value), LEN(SUM(Value))&")",SUM(Value))
Anonymous
Not applicable

thanks for your reply.

 

actually, i have this formula for my profit & loss

 

   p&l.all = [total.inc.all]-[total.exp.all]
 
& if there's a negative value to the result, i'd like the negative-value result(s) to be in bracket & in red color e.g. ($100).
 
currently, the currency formatting that i'm using is from the general formatting under modelling that doesn't seem to allow what i need & reflected above.
 
looking forward to that resolution.
 
tks & krgds: -nik-

You need two measures one for conditional formatting
1)
m1 =IF ([total]>0,FORMAT ([total] , "+0.00%;-0.00%" ),
"("& FORMAT ([total] , "+0.00%;-0.00%" )&")"
)
2)
CF Font =if([total]<0,"#F80000")

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.