Forum Discussion
How to pass multiple values in advance filtering
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.
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
This is not what I needed.
Regards,
Akhil.
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