Basic question on placing more than 2 filters on PBI desktop

[Ricardo77]

Hello, i need to place 5 "is not" filters on a visual and PBI Desktop only has space for 2. I can use the trick that, with basic filter, i select all, unselect 5, save the report and change to advance filtering, allowing me to change the 5 filters content. The doubt is, while i can so this on latest version of PBI desktop with a dummie table from excel, i can not so this over my report. So, why this strange behavior from PBI?

 

[Anonymous · Accepted solution]

Hi @Ricardo77 ,

As far as I know, if we go directly to Advanced filtering it will only show two criteria. However, if you start with Basic filtering and then select the values for your criteria and then select Advanced filtering those criteria show like what your're experiencing.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：More than 2 values for advanced filtering

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Or you can try to create a measure to filter your visual.

Measure = 
VAR _NOT_LIST = {"B","C","D","E","G"}
Return
IF(MAX('Table'[Category]) in _NOT_LIST,0,1)

Add this measure into the visual level filter and set it to show items when value =1.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Ricardo77 , First got to basic filtering and select 5 values and then change it to advance , you will get 5 options

[HM615]

This solution works if you have enough values in your dataset to be able to select the number of values you want - but it isn't a given that you will! I am prepping reports for an upcoming event, so have very little data in my dataset now - but I need to flag the relevant values for when things kick-off, and currently have no way of doing that. It's bonkers!