Forum Discussion
Conditional Formatting to One value in a column
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
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.
2 Replies
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
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.
