Forum Discussion
Multiple AND condition in Visual level filter
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.
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/771124/highlight/true
9 Replies
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/771124/highlight/truevojtechsima this is great. Would you consider this a bug or a missing feature 😀?
moizsherwani ,
I would say, it's never a bug, it's always a feature 😀
Hello Sir,
Thanks for the solution. It is working as expected.
Goddam this software is stupid
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
