Forum Discussion
Solved
Conditional formatting in Matrix
Hi! I'm trying to do some conditional formatting on my matrix visual. There are a few conditions that I need to have: 1) If value > 100%, colour red 2) Based on the above, all months before the lat...
Thank you for the reply KHMJ
Here is the correct measureConditional Formatting = VAR CurrentMonth = SELECTEDVALUE ( Table[Month Index] ) VAR T1 = CALCULATETABLE ( Table, REMOVEFILTERS ( Table[Year - Month], Table[Year Month Index], Table[Month Index] ) ) VAR T2 = SUMMARIZE ( T1, [Month Index], "%Load", [% Load] ) VAR T3 = FILTER ( T2, [%Load] > 1 ) VAR LastMonthAbove100 = MAXX ( T3, [Month Index] ) VAR Result = IF ( CurrentMonth <= LastMonthAbove100, "#ff7276", IF ( CurrentMonth IN { 2, 3 }, "#ffa500", "#f8f8ff" ) ) RETURN ResultIn T1 variable, please make sure to remove the filter from all the columns related to year month.
Have a great day!
Hi KHMJ
You may try the following
Conditional Formatting =
VAR CurrentMonth =
SELECTEDVALUE ( Table[Month Index] )
VAR LastMonthAbove100 =
CALCULATE (
MAX ( Table[Month Index] ),
[% Load] > 1,
REMOVEFILTERS ( Table[Month Index] )
)
RETURN
IF (
CurrentMonth <= LastMonthAbove100,
"#ff7276",
IF ( CurrentMonth = 1 || CurrentMonth = 2, "#ffa500", "#f8f8ff" )
)Or
Conditional Formatting =
VAR CurrentMonth =
SELECTEDVALUE ( Table[Month Index] )
VAR LastMonthAbove100 =
CALCULATE (
MAX ( Table[Month Index] ),
[% Load] > 1,
REMOVEFILTERS ( Table[Month Index] )
)
RETURN
IF (
CurrentMonth <= LastMonthAbove100,
"#ff7276",
IF ( CurrentMonth IN { 1, 2 }, "#ffa500", "#f8f8ff" )
)
