Multiple AND condition in Visual level filter

[Murali777]

Hi All,

I'm working on the existing powerbi project and it contains Multiple AND condition in the visual level filter. But when i'm recreating the same in the New Powerbi report, I couldn't able to add more than 2 filters. Please find the screenshot below for your reference. Kindly guide me how to add more than two advance filtering option in the visual level filter like in below screenshot.

[karendcobb]

But once you clear the filter, it goes back to only 2 options

[Anonymous]

Hi the AND filter besically creates a subset of values that fullfills the two AND condition simultaneously. This is why the addition to the third AND filter is limited. 

[vojtechsima · Accepted solution]

Hello, @Murali777 ,
You gotta trick the Power BI first, you select 3 random values in Basic Filtering and then you go to Advanced Filtering and you will now have 3 options:

This threat was dealing with it first:
https://community.powerbi.com/t5/Desktop/Create-an-advanced-filter-with-more-than-2-options/m-p/7711...

[Murali777]

Hello Sir,

Thanks for the solution. It is working as expected.

[moizsherwani]

@vojtechsima this is great. Would you consider this a bug or a missing feature 😀?

[vojtechsima]

@moizsherwani ,
I would say, it's never a bug, it's always a feature 😀

[moizsherwani]

@Murali777 I have never seen anything like this (maybe a bug from a previous version?). Normally if you had to put multiple filters on a visual I would propose

(1) creating a measure with those filters and applying it to the visual

(2) dragging the same field multiple times on a visual and have those multiple "is not" conditions 

Would love to hear from the other experts here

[tej147]

Hi Murali,

The trick is 

Step 1 In Basic Filtering, select any 3 checkboxes (just for now)

Step 2 Now change the option to Advance filtering

Step 3 You will see 3 conditions.

If you found this helpul, please accept this as a solution and give kudos!