Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to use SWITCH Function for font color but it doesn't work. Only works With IF Function but is limited the quantity of variables to use. I want to use SWITCH or other function that can work with unlimited quantity of values/measures.
SWITCH not working:
IF function working but Limited:
if I try to use more than 6 then it shows an error:
Any idea why is not working ?
Solved! Go to Solution.
@cristianml , What [_Actual Rev] here, just a measure, then all non zero will be true are you looking for
selectedvalues(measure[measure]) = "_Actual Rev","#000000"
refer examples
Colour =
SWITCH(TRUE(),
'Table'[Date] < TODAY(), "red",
'Table'[Date] = TODAY(), "orange",
"green")
Colour =
SWITCH(TRUE(),
max('Table'[Month Year]) = "Jan-2020", "red",
Max('Table'[Month Year]) < "Feb-2020", "orange",
//keep on adding
"green")
Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)
@cristianml , What [_Actual Rev] here, just a measure, then all non zero will be true are you looking for
selectedvalues(measure[measure]) = "_Actual Rev","#000000"
refer examples
Colour =
SWITCH(TRUE(),
'Table'[Date] < TODAY(), "red",
'Table'[Date] = TODAY(), "orange",
"green")
Colour =
SWITCH(TRUE(),
max('Table'[Month Year]) = "Jan-2020", "red",
Max('Table'[Month Year]) < "Feb-2020", "orange",
//keep on adding
"green")
Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)