Forum Discussion
Solved
Conditional Formatting using DAX measure
Hello there, I'm trying to do a conditional formatting using a dax measure. I need to add a conditional format to the column vFCT based on a month progress: Progress = (DAY(TODAY()...
Hi Dvilches_ ,
This is conditional formatting of background color, so I think the measure need to return the color code. I think you need to change measure like below to see whether it work or not.
Measure = var aa=(DAY(TODAY())-1)/DAY(EOMONTH(TODAY(),1)) return SWITCH(TRUE(),aa<0, "#fcba03", aa<0.05,"#aaf0ad", aa<1, "#b8ecf5",aa>=1,"#c7acfc")Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dvilches_ ,
This is conditional formatting of background color, so I think the measure need to return the color code. I think you need to change measure like below to see whether it work or not.
Measure = var aa=(DAY(TODAY())-1)/DAY(EOMONTH(TODAY(),1)) return SWITCH(TRUE(),aa<0, "#fcba03", aa<0.05,"#aaf0ad", aa<1, "#b8ecf5",aa>=1,"#c7acfc")
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.