Forum Discussion
Conditional Formatting based on column value
Hi lesg
Your measure may have some issues so that you cannot choose the measure, you can try the following measure:
Measure = if(SUM('Table'[Required Cover])>=SUM('Table'[on Hand]),"Green","Red")
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,
Thanks for that suggestion, however, when I try and add, I get an error:
The cover is a measure created work out how much stock should be required and not an actual column in the table?
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:
Thank you!
