Forum Discussion
Conditional Formatting based on column value
Hi lesg
You can try the following code :
Measure = if([Cover]>=SUM('Table'[on Hand]),"Green","Red")and you need to put the measure to the conditional formatting:
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yolo,
I dont understand what you mean, How can I add the function to the conditional formatting, there is no option to add a measure? as as per my original post, the measure I created, shows in dropdown, but does not show as an option when selected in the dropdown:
Hi lesg
The measure you have created is a calculated measure, you cannot put it to the conditional formatting, you need to create a measure like the measure I have offered, then you can put it to the conditional formatting, the measure I have created is give the condition to change the color. you can refer to the attachments I supplied above.
and you can refer to the following link:
Conditional Formatting Using Custom Measure - Microsoft Power BI Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.