Conditional Formatting to One value in a column

[RanjanThammaiah]

Hi All,

Is there any way I can apply conditional formatting to the only YTD in a Period type field?

Actuals Greater than Full Year plans then Red else Green. Currently, it's applying for all WTD, MTD, and YTD. but I need the formatting should only for YTD.

  

Regards,

Ranjan

[v-angzheng-msft · Accepted solution]

Hi, @RanjanThammaiah 

Try to create a measure like below:

_Color =
IF (
    MAX ( 'Data'[Period Type] ) = "YTD",
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( Data[Actuals] ) > SELECTEDVALUE ( Data[Full Year Plan] ), "Red",
        "Green"
    )
)

Sample:

Result:

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@RanjanThammaiah , You can but a condition like

With help from conditional formatting measure you can do

color =

if(max(Period Type]) ="YTD" ,

Switch ( true()

[Measure] < 100000 ,"red",

// add conditions 

"Green"

), "White")

Use in conditional formatting using field value option

refer for steps

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4