Forum Discussion

Akhil01's avatar
Akhil01
Frequent Visitor
7 years ago

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.

 

General Comment
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      This is not what I needed.

       

      Regards,

      Akhil.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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