How to pass multiple values in advance filtering

[Akhil01]

Hi All,

Is there any way where user can pass multiple values instead of two values in advance filtering. 

if not any workaround for this also appreciated.

Thanks in advance.

[Anonymous]

HI @Akhil01 ,

AFAIK, advanced mode not support more than two values.
If you want to filter more values, you can consider to write a measure to compare current items and specific values then return tag.

Measure =
VAR currValue =
    SELECTEDVALUE ( Table[Column] )
VAR _list = { "A", "B", "C", "D", "E", "F" }
RETURN
    IF ( currValue IN _list, "Y", "N" )

Then you can use this measure on visual level filter to check 'Y' result.

Regards,

Xiaoxin Sheng

[Anonymous]

This is not what I needed.

Regards,

Akhil.

[Anonymous]

HI @Anonymous ,

If my suggestion not suitable for your requirement , you can consider to submit an idea for this requirement or switch to base mode to selection multiple values.

Regards,

Xiaoxin Sheng