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!

     

richbenmintz's avatar
richbenmintz
Resident Rockstar
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!

 

  • dmoggie's avatar
    dmoggie
    Helper I
    6 years ago

    Wow so many quick replies, what a great forum. I didnt know you could resolve in all these different ways

     

    tex628 thanks.

     

    This was the missing bit for me. Many thanks richbenmintz 

     

    Kind Regards