Forum Discussion
Use slicer value in conditional
I want to be able to populate the Category column depending on the values selected by the slicer. Slicer 1 1, 2 or 3 Slicer 2 4, 5 or 6 Value Category 1 A 2 A 3 A 4 B...
Try the below.
Category =
var category_value_A = selectedvalue([Slicer 1])
var category_value_B = selectedvalue(Slicer 2])
return
switch(TRUE, [Value] <= category_value_A, "A",
[Value] >= category_value_B, "B",
"C")