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 additiona...
Need Help
Show and Tell
Tips and Tricks
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks, Seanan 

         

        Yeah, the idea would be for the dashboard user to be able to add/remove conditions, so won't work to have in the code 😞

         

        Thanks again!

        Sonia