Conditional Formatting using DAX measure

[Dvilches_]

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())-1)/DAY(EOMONTH(TODAY();1))

The problem is in conditional format based on field value:

i cannot select the measure.

Any suggestion?

Thanks in advance.

[dax · Accepted solution]

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.

[Anonymous]

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