Forum Discussion

AravindhPi's avatar
AravindhPi
New Member
2 years ago

Help Needed: Filtering Visuals with User-Selected Value in Multi-Value Columns

Hi everyone,   I'm facing an issue with filtering visuals based on user selections and could really use some help. Here's the situation:       I have a column in my table that contains multiple v...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AravindhPi ,

Based on my testing, please try the following methods again:

1.Create the simple table.

2.Drag the fruit field into the slicer visual.

3.Create the new measure to filter the column contains selected value.

Measure = 
var frui_ = SELECTEDVALUE('Table test'[Fruit])
var t_fruit = SELECTEDVALUE('Table'[Sales])
RETURN
IF(CONTAINSSTRING(t_fruit, frui_), 1, 0)

4.Set the show items is 1 in filters pane.

5.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.