Adding additional filters in advanced filtering panel

[Anonymous]

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

[Seanan]

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]

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]

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]

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

[amitchandak]

@Anonymous , I think as of now you have to work with a workaround using basic filtering.

You can log and idea for better UI - https://ideas.powerbi.com/ideas/