Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Adding additional filters in advanced filtering panel

Hi there, 

 

Does anyone know if it's possible to 'add' additional filtering conditions in the 'advanced filtering' section?

 

I can add 1 field either side of the AND/OR, but can't add additional ones below (eg: x OR y OR y etc.) 

 

The only way I've found possible is if I revert back to 'basic filtering' and select some additional items. When i return to advanced it has these additional fields listed. But then with this option, you're unable to remove

Anyone have any ideas for this? Seems strange that you can only add two items. 

 

Thank you!

Sonia

Need Help
Show and Tell
Tips and Tricks

5 Replies

  • Seanan's avatar
    Seanan
    Icon for Solution Supplier rankSolution Supplier
    4 years ago

    Hi Anonymous 

    You could try using a calculated column to achieve what you want. Please see the following code:

    Filter = SWITCH(TRUE(),CONTAINSSTRING('SalesTeam'[Company],"Test1") || CONTAINSSTRING('SalesTeam'[Company],"Test2") || CONTAINSSTRING('SalesTeam'[Company],"Test3"),"Filter")

    Then add this column in the filters pane.

     

     

     

     

     

    Please let me know if this works.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Seanan , 

       

      Unfortunately this one doesn't work for my use case. 

       

      I'd like to be able to have 'and'/'or' functionality, using as many items as I'd like. 

       

      Thank you anyway... i guess i'll have to wait for a new feature update. 

       

      Sonia

       

       

      • Seanan's avatar
        Seanan
        Icon for Solution Supplier rankSolution Supplier
        4 years ago

        Hi Anonymous 

        The filter code above can be adjusted to hold as many and/or condtions are you'd like. However, it would be a lot of manual overhead if you needed to add or remove conditions.

        Hopefully there is a release soon that will be better suited to your requirements.