Conditional Formatting

[Niraj_vora0106]

Hi community,

I've a doubt regarding Conditional Formatting.

Suppose I've a column Year, in that I've two values FY20 and FY21.

Is it possible to give conditional formatting like Background colors or Icon only to FY20?

Because as much as I know Conditional formatting works for whole particular column rather than single values inside it.

Please help!

[v-zhangti · Accepted solution]

Hi, @Niraj_vora0106 

You can try the following methods.

Color = IF(SELECTEDVALUE('Table'[Year])="FY20","Green",BLANK())

Does this meet your desired outcome?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

You can set a rule like:

If Year = FY20 then *select the icon*

You don't need a rule for the FY21