Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Three Criterions on Filters

Hello everyone,   I found that here we can maximum have just 2 criterion, can we have more than 3?   Thanks in advance,   Best regards, Hanson
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi you could create a custom column that if the CustomerGroup contains Type A or Type B or Type C, mark them as "Y", others mark as “N”. Then filter this custom column. Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Fowmy,

 

Sorry can't share data, just make up a simple case, if I want a filter of CustomerGroup contains 'Type A' or 'Type B' or 'Type C', what should the measure looks like?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

You can set search with Basic filtering for the related data in Filters pane or create a slicer just like below screenshot:

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous thanks for reply, Reality is a bit of more complex,
    It might be column A contains "A" or column B contains "B" or column C contains "C"

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

      You can apply multiple columns filter in Filters pane just as below screenshot:

      Best Regards
      Community Support Team _ Rena Ruan
      If this post helps, then please consider Accept it as the solution to help the other members find it more.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Anonymous If so, the three filters are in AND relationship or OR relationship?