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!

     

tex628's avatar
tex628
Community Champion
6 years ago

Assuming that it's measures you have it should be something along the lines of:

Measure = 
IF( [Measure 1] < [Measure 2] , 1 ,
IF( [Measure 1] < [Measure 3] , 1 ,
IF( [Measure 1] < [Measure 4] , 1 , BLANK()
)))


If you're just column aggregating i would recommend creating 4 measures instead:

Measure 1 = SUM(Table[Column1])

etc. 

Finally apply conditional formatting to Measure 1 and use the "Based on field" condition: 

Where you choose the measure written above with the condition 1 = Colored

Br,
J