Forum Discussion
Conditional Formatting for negative values with 3 conditions
Hi Experts, I want to do the conditional formatting of negative values as mentioned below. How can I achieve it with icons. also , please please let me know how to work with numbers or percen...
Thanks for your reply. I used your formula but its showing me below results still (only red icons appear)
Follow this.
Create a DAX measure for an icon.
Icon = UNICHAR(11044)Use this measure in your table visual.
Create another measure for conditional formatting.
Color =
VAR MYVALUE = [Difference %]
VAR RESULT =
IF (
MYVALUE > -1
&& MYVALUE <= -0.05,
"green",
IF (
MYVALUE > -0.05
&& MYVALUE <= 0,
"orange",
IF (
MYVALUE > 0
&& MYVALUE <= 100,
"red",
BLANK ()
)
)
)
RETURN
RESULTThen format the Icon (Font) measure field using the newly created "Color" measure.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
nandukrishnavs- Superb, That worked perfectly. Many Thanks.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂