Forum Discussion
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:
i cannot select the measure.
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.
2 Replies
Hi Dvilches_ ,
It looks like your Measure has a numeric value.
For the Field value Conditional Formatting your data should be either in Text value or in Hex code.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
why dont you use Rules condiitonal formatting in your case. you can specify the range you want to highlight.
Thanks,
Tejaswi
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.
