Forum Discussion
Conditional formatting with filters
Hi, try with this:
A measure to apply the color :
Color = VAR _Sales = SUM ( Sales[Sales] ) VAR _Group = SELECTEDVALUE ( Sales[Group] ) RETURN SWITCH ( _Group, "Group 1", SWITCH ( TRUE (), _Sales <= 0,18, "#ff0000", _Sales < 0,21, "#ffa500", "#00ff00" ), "Group 2", SWITCH ( TRUE (), _Sales <= 0,14, "#ff0000", _Sales < 0,18, "#ffa500", "#00ff00" ), "Group 3", SWITCH ( TRUE (), _Sales <= 0,24, "#ff0000", _Sales < 0,28, "#ffa500", "#00ff00" ) )Note: You can improve this if work with a table and the range color by each group.
Finally , in conditional format Select Format by Field Value and choose the measure (In this case Color)
Ready
Victor
Hi,
How can I use the measure as a Conditional formatting,
Like Zone 1 = MinObj: 30%
Obj: %35
Zone2 = MinObj: 38%
Obj: 45%
Thanks!
Hi, try with this:
A measure to apply the color :
Color =
VAR _Sales =
SUM ( Sales[Sales] )
VAR _Group =
SELECTEDVALUE ( Sales[Group] )
RETURN
SWITCH (
_Group,
"Group 1", SWITCH (
TRUE (),
_Sales <= 0,18, "#ff0000",
_Sales < 0,21, "#ffa500",
"#00ff00"
),
"Group 2", SWITCH (
TRUE (),
_Sales <= 0,14, "#ff0000",
_Sales < 0,18, "#ffa500",
"#00ff00"
),
"Group 3", SWITCH (
TRUE (),
_Sales <= 0,24, "#ff0000",
_Sales < 0,28, "#ffa500",
"#00ff00"
)
)
Note: You can improve this if work with a table and the range color by each group.
Finally , in conditional format Select Format by Field Value and choose the measure (In this case Color)
Ready
Victor
Hey!
Seems that it can work, but when I fill the measure with the values, it returns me a warning,
"Argument "n" in SWITCH function is required." If I keep filling the function, the "n" Argument increments, and I can't solve the issue, may be im getting lost at some point.. Thanks a lot guys!
Hi, Switch Function is more useful when had 2 or more conditions to evaluate.
I think after your last "; " enter the 2nd condition of GroupZon
Regards
Victor
------------------------------
Hola Veo que también hablas español. La funcion Switch idealmente evalua más de 1 escenario. En tu caso veo que solo estás evaluando cuando GroupZon es 1. Si sólo es eso borra la última ";" . Sino a partir de ahí tienes que ingresar el siguiente escenario a evaluar.
Hi,
Yes yes, that was just a portion of the code, I have this, with more than 50 groups. I add here just 7,.
Color =
VAR _Avisos = SUM(PartesMantAvisos[ID_Procedencia])
VAR _GrupZon = SELECTEDVALUE(PartesMantAvisos[Grup_Zon])
RETURN
SWITCH(
_GrupZon;
"1"; SWITCH(
TRUE();
_Avisos <= 0,30; "#00ff51";
_Avisos <= 0,35; "#ff9a00";
"#ff0000"
);
"2"; SWITCH(
TRUE();
_Avisos <= 0,30; "#00ff51";
_Avisos <= 0,35; "#ff9a00";
"#ff0000"
);
"3"; SWITCH(
TRUE();
_Avisos <= 0,38; "#00ff51";
_Avisos <= 0,33; "#ff9a00";
"#ff0000"
);
"4"; SWITCH(
TRUE();
_Avisos <= 0,30; "#00ff51";
_Avisos <= 0,35; "#ff9a00";
"#ff0000"
);
"5"; SWITCH(
TRUE();
_Avisos <= 0,33; "#00ff51";
_Avisos <= 0,38; "#ff9a00";
"#ff0000"
);
"7"; SWITCH(
TRUE();
_Avisos <= 0,24; "#00ff51";
_Avisos <= 0,28; "#ff9a00";
"#ff0000"
);
"9"; SWITCH(
TRUE();
_Avisos <= 0,21; "#00ff51";
_Avisos <= 0,25; "#ff9a00";
"#ff0000"
);But I still have the same error: Argument 'n' in SWITCH function is required.
Thanks!
Hey,
After a few hours working with this topic i'll managed to find the solution,
Thanks a lot! It works :D