Conditional formating using a Measure

mslino — Thu, 21 Sep 2023 12:31:56 GMT

Hi!

I created a measure to be used in a Matrix usinf the bellow code:

Measure 2 = IF ( ISINSCOPE('Table[nm_mdld]), VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1 VAR grade = SWITCH(TRUE, indx <= 0.01, "1", indx > 0.01 && indx <= 0.05, "2", indx > 0.05 && indx <= 0.10, "3", indx > 0.10 && indx <= 0.20, "4", indx > 0.20, "5") RETURN grade, VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1 VAR grade = SWITCH(TRUE, indx <= 0.01, "1", indx > 0.01 && indx <= 0.05, "2", indx > 0.05 && indx <= 0.10, "3", indx > 0.10 && indx <= 0.20, "4", indx > 0.20, "5") RETURN grade )

I would like to use the value in the Measure 2 e.g. (1,2,3,4,5) to change it´s cell color, but I was unable to find a solution. I´m newbe in DAX .

Regards.

Re: Conditional formating using a Measure

lbendlin — Sat, 23 Sep 2023 16:41:12 GMT

instead of returning "1" you can return the name of the color.

Measure 2 = IF ( ISINSCOPE('Table[nm_mdld]), VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1 return SWITCH(TRUE, indx <= 0.01, "red", indx <= 0.05, "pink", indx <= 0.10, "yellow", indx <= 0.20, "orange", "green") )

and then color by "field value".

topic Conditional formating using a Measure in DAX Commands and Tips

Conditional formating using a Measure

Re: Conditional formating using a Measure