Filters with logical Operators

[MokaSatya]

Hello Experts,

Do we have any option to increase the conditions in the filter or a Advanced slicer to filter based on And\Or operators?

Here is my customer requirement, 

In the report he need an option to filter the column based on logical operators , i have eabled the filters in the report to use Advanced filter option, find the screenshot below, here it supports only 2 conditions. but the requirement is with more conditions (Title contains "Outlook" OR Title contains "OWA" AND Title Contains "Not Working".... etc), customer change these conditions to analyse the trend.

Can you please suggest the solution? 

Best Regards

Satya

[JAWL]

How do you enable advanced filter in PowerBI?

[amitchandak]

You can create a measure with multiple filter

calculate([Measure], filter(table,<Condition>&&/|| <Condition>))

[MokaSatya]

I am looking for a provision to provide the filter option to the end user . in this senario we are projecting Tickets information in the report with a daily Ticket volume and a Table with Tickets, daily volume is around 20K. requirement is to provide a provision to end user to filter the data based on his Text search.

suppose end user would like to filter the data with 3 or 4 conditions using AND\OR operators  , how to do that?, slicer dont have option to filter data with Logical operator, and i see filter feature in power bi support only 2 conditions at once like in the screenshot provided.

[v-kelly-msft · Accepted solution]

Hi @MokaSatya ,

You can plot multiple slicers to make them function as filters,such as below:

Here is a reference about slicer : https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!