Conditional Formatting Measure

[austin15g]

Hello,

I'm using the below measure for some conditional formatting. It appears to be working as expected for the values that fall below my threshold. However, I can't get it to work for blank values for some reason. I've done troubleshooting and set up a dummy measure to ensure that the values that I am looking to conditionally format as light red are in fact pulling in as BLANK, but the measure is still giving issues for some reason. I've tried building in ISBLANK and BLANK separately, but neither seems to be doing the trick. In the screenshot of my table visual below, the yellow highlights are correct, but the blank value in the February column should be highlighted as light red.

When I change my conditional formatting to basic conditional formatting, the blank values highlight correctly (note: April and May data is dummy data)... I'm wanting to use a measure so that the future months in my table remain unchanged and not highlighted red.

Thank you in advance for any help!

[amitchandak · Accepted solution]

@austin15g , As of now, blank value is only supported in gradient and rule-based conditional formatting, not for field value-based.

[austin15g]

Okay that clears it up. Thank you!