Forum Discussion
dmoggie
6 years agoHelper I
Conditional formatting help required?
Hi All, I Seem to be stuck at what should be quiet a simple task. I have a table with four columns (fields) per row. All i want to is highlight each time the value in column 1 is less than a...
- 6 years ago
Hi dmoggie
You can create the following Measure
back color = if(COALESCE([Val 1]<[Val 2], [Val 1]<[Val 3], [Val 1]<[Val 4])= BLANK(), "#FFFFFF", "#008000")then use the Format by Field Value type of conditional formatting
Linkt to Sample pbix, sample.pbix
Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
richbenmintz
6 years agoResident Rockstar