Skip to main content

Power BI

Needs Votes

More than 2 values for advanced filtering

Vote (316) Share
Oscar Broekman's profile image

Oscar Broekman on 10 Oct 2015 01:40:00

In Power BI Desktop, in 'Report Level Filters', we would like to be able to filter on more than just 2 values in advanced filtering

Comments (19)
Oscar Broekman's profile image Profile Picture

Peter van Bergen on 27 Jun 2024 09:44:03

RE: More than 2 values for advanced filtering

Also still waiting for the simple (+) function. Adding more filter criteria in advanced filtering should already be available, but unfortunately it is not.

Oscar Broekman's profile image Profile Picture

Cory Gibson on 25 Mar 2024 16:45:05

RE: More than 2 values for advanced filtering

2024 now and still not implemented. My major issue is I have more to filter than the amount showing in the BASIC, so I simply can't do it with an OR.

Oscar Broekman's profile image Profile Picture

Liam McHugh on 15 Aug 2023 06:15:25

RE: More than 2 values for advanced filtering

How has this still not been implemented? Its a major shortfall and aggravating inconvenience, while seeming like a pretty easy function to add.

Oscar Broekman's profile image Profile Picture

Paul Bailey on 13 Apr 2021 17:36:56

RE: More than 2 values for advanced filtering

You can do the "Basic" filter and then change it to "Advanced" to work around this limitation for now.

Oscar Broekman's profile image Profile Picture

Karen Lillystone on 22 Jul 2020 14:22:57

RE: More than 2 values for advanced filtering

Please can this be implemented? we want the ability to filter on the report in some instances, and this need this facility where we would need over 2 values!

Oscar Broekman's profile image Profile Picture

Power BI User on 06 Jul 2020 00:05:57

RE: More than 2 values for advanced filtering

Ultimately you should be able to filter by every category, no matter the number.

Oscar Broekman's profile image Profile Picture

Power BI User on 06 Jul 2020 00:01:02

RE: More than 2 values for advanced filtering

This is such a glaring functionality gap and highly frustrating I might add. I must have a dozen of specific keywords I must filter on with wildcards, etc....

Oscar Broekman's profile image Profile Picture

Toshik on 05 Jul 2020 23:58:41

RE: More than 2 values for advanced filtering

Power BI Pro too..

Oscar Broekman's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:54:05

RE: More than 2 values for advanced filtering

The hacky workaround doesn't seem to work on AAS Hierarchy fields.

Oscar Broekman's profile image Profile Picture

Power BI User on 05 Jul 2020 23:53:43

RE: More than 2 values for advanced filtering


If you know how many values you want to search start off in basic mode and select that #, then switch to Advanced. It creates all the filed for you..