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...
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.