Forum Discussion

dmoggie's avatar
dmoggie
Helper I
6 years ago
Solved

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...
Need Help
  • richbenmintz's avatar
    richbenmintz
    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!

     

dedelman_clng's avatar
dedelman_clng
Community Champion
6 years ago

Hi dmoggie  - create a measure or a column (depending on what your values are already), that produces 1 if your condition is met and 0 if it doesn't.  Then do conditional formatting on that field, but using the value of the new measure/column.

 

Hope this helps

David