Forum Discussion
datadelta
3 years agoHelper III
Having difficulty with conditional formatting using a formula and both items are numbers
I'm trying to make a conditional formatting comparing two data points in order to reflect red if lower and green if equal or higher. I created a column and wrote the forumual but DAX is telling m...
- 3 years ago
I solved this. I rewrote the formula. Thank you for your help!
datadelta
3 years agoHelper III
Thank you. Okay, I got it to display a response but I was looking to change the color of the "actual days" data point. This just added a field to my data. Should I not be using "New Column"? I have the true / false as "1" and "2" to see if the formula worked. I did received the 1's and 2's but not really the outcome I needed.
Thank you
Kishore_KVN
3 years agoSolution Sage
You can use it either with 'IF' or 'SWITCH' functions. Please let me know the DAX of measure or column that you are writing. If I can modify it I will try to help you in that.
Between please mark the relevant reply as solution so that others can reach there fast. Thanks.