Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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-
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
If your found this heplful, please vote..thanks.
Hi,
You would try to do this with a Measure
Measure:= IF (SUM(Value) <0, "("&LEFT(SUM(Value), LEN(SUM(Value))&")",SUM(Value))
thanks for your reply.
actually, i have this formula for my profit & loss
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |