Forum Discussion

dmoggie's avatar
dmoggie
Icon for Helper I rankHelper 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!

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

dmoggie , create a color measure like this and use that in conditional formatting with "Field" option

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

 

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values