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 |
| 5 | B |
| 6 | C |
| 7 | C |
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")
I have tried the code above and it only works for the first condition and then exits the switch.
3 Replies
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")Hi theaddies ,
May I ask if your [Slicer1] and [Slicer2] are the following two columns?
Here are the steps you can follow：
1. Create measure.
Measure = var category_value_A = MAXX(ALLSELECTED(Slicer_Table),[Slicer1]) var category_value_B = MAXX(ALLSELECTED(Slicer_Table),[Slicer2]) return SWITCH( TRUE(), MAX('Table'[Value])<=category_value_A,"A", MAX('Table'[Value])>category_value_A&&MAX('Table'[Value])<=category_value_B,"B", "C")2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Each slicer is a generated series. The Maxx function does not work as it selects the final value in the series.
