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...
speedramps Thank you. I added the measure provided by you but it only gives me the 'red' icons only. Below is the screenshot
Here is the DAX
MyICON =
VAR MYVALUE = [Difference %]
RETURN
SWITCH(TRUE(),
MYVALUE<-100,BLANK(),
Myvalue <= -5, UNICHAR(128994), -- green if > -100 and <= -5
Myvalue <= -0, UNICHAR(128993), -- yellow if > -5 and <= 0
Myvalue <= 100 , UNICHAR(128308), -- red if >0 and <=100
BLANK()
)
Hi again adhumal
In my instructions it did say ...
VAR Myvalue = -4 -- substitute this hard code value with your measure and multiply with 100 if a %
but unfortunately you have done this
VAR MYVALUE = [Difference %]
[Difference %] has a percent datatype so 13% will be stored as 0.13
and therefore 0.13 is less than 5
If you tweak it will work.