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!

     

Anand24's avatar
Anand24
Super User
6 years ago

Hi dmoggie ,

 

Follow the below steps:

1. Create a new column with below condition:

Color_Column = if(Tablename[Column1] < Tablename[Column3],"Color's Hex Code","")
 
2. Go to Format -> conditional Formatting -> Enable Background color -> Format by: Field Value and Based on Field: Color_Column
 
Check below for example(Highlight Column1(Sixes) if No. of Sixes < No. of Fours(Column3)):
 
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!