Forum Discussion

TRADER083's avatar
TRADER083
Helper II
3 years ago

Conditional Formatting based on Field Value does not apply to all values in table/matrix

Hi everyone,

 

I have created a measure (see below) that can be applied to Conditional Formatting for Field Value. I've used it on many table/matrix to hide values if no filter is applied without any issue.

 

Color_Transparency =

    var filter_check = HASONEVALUE(table1[filter1])
    var color = if(filter_check = true,"","hsla(0, 0%, 0%, 0)")

return color

However, one matrix has an issue where a number which conditional formatting has not been applied. Not sure what the issue is.

Before applying conditional formatting:

After applying conditional formatting:

 

No RepliesBe the first to reply