Forum Discussion
harirao
4 years agoPost Prodigy
Custom icons for conditional formatting not working
Hi All, I want to create conditional formatting using Icons based on the percentage measure created, below are the conditions which i want to use in Matrix table But i am unable to use last...
- 3 years ago
Hi harirao
Thanks for reaching out to us.
In your screenshot, logic used is and, not or.
please try this measure,
Measure = var _value= MIN('Table'[Attainment]) return SWITCH(TRUE(), _value>0.75 && _value<0.85,"yellow", _value>0.85 && _value<1.15,"green", _value>1.15 && _value<1.25,"yellow", _value<0.75 || _value>1.25,"red")result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.