Skip to main content

    Power BI

    Needs Votes

    More than 2 values for advanced filtering

    Vote (226) 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 (15)
    Oscar Broekman's profile image Profile Picture

    1fe0be8c 3ecb-ea11-a812-000d3a8ddfb2 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

    a429ee65 e0fc-4363-99ae-3a3b0e5f8c3e 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

    271b5d21 adab-4b0b-8511-26c665969a07 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

    ece253c6 d0cc-43e9-8ca0-5405e2aa6931 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    12de383b ad2b-4ac6-82e9-af394947f5ae 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..

    Oscar Broekman's profile image Profile Picture

    c1a9e4ce 80be-495e-bf1f-526df6319a05 on 05 Jul 2020 23:42:17

    RE: More than 2 values for advanced filtering

    It's possible to get around this: https://codeover.io/powerbi-advanced-filters-creating-more-than-2-options/

    Oscar Broekman's profile image Profile Picture

    fd1e6699 f18f-4103-8218-8e1f07c92e82 on 05 Jul 2020 23:29:23

    RE: More than 2 values for advanced filtering

    There is a work-around, albeit it is pretty hacky.

    If you have a decent sized list under the "basic fitlering" option, you can purposefully select a number of those items. That will have power BI list the filter as something like:
    "X and Y and Z and ..."

    Then, with that filter turned on, swap to the advanced filtering. You will see an option representing each of the "and"s. You can then change those from "equals" to whatever advanced filter you want.

    Oscar Broekman's profile image Profile Picture

    f92edb87 331f-4fdf-9e4a-6952445b8f9c on 05 Jul 2020 23:29:23

    RE: More than 2 values for advanced filtering

    Yes, please add support for "is in list" or "is not in list" so we can paste long list of values. There was another idea similar; in those comments, someone pasted this:
    https://ideas.powerbi.com/forums/265200-power-bi-ideas

    Oscar Broekman's profile image Profile Picture

    62e1e584 e922-4856-a57e-23ff5d790a47 on 05 Jul 2020 23:27:33

    RE: More than 2 values for advanced filtering

    It would be nice to start with 1 value and then have an "add value" option that would allow the user to add as many as they need