Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
@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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |