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

    6691c187 ac5d-4352-8a9e-2072d6aba932 on 05 Jul 2020 23:23:32

    RE: More than 2 values for advanced filtering

    "Advanced" filtering is an oxymoron when i have to go to Basic Filtering and work through a list of 200+ items

    Oscar Broekman's profile image Profile Picture

    31d648f4 0543-47eb-b50e-9aa4213c5521 on 05 Jul 2020 23:10:23

    RE: More than 2 values for advanced filtering

    Would be nice and really effective to have the same feature that are in the filter visual (like for example the lens option and dropdown menu....)

    Oscar Broekman's profile image Profile Picture

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

    RE: More than 2 values for advanced filtering

    Please add something like the "IN (var1, var2, .....)" syntax from SQL

    Oscar Broekman's profile image Profile Picture

    eedcc397 901d-415d-af2b-71496addf78c on 05 Jul 2020 22:29:36

    RE: More than 2 values for advanced filtering

    PBI Desktop and Service, and at any level filter; it would be nice to specify an "in list" of values as opposed to just 2. I have thousands of records (users) where I'd like to filter x number of them; not just 2.

    Oscar Broekman's profile image Profile Picture

    4ef379c6 c03e-443c-8150-e73bd00593ab on 05 Jul 2020 22:19:44

    RE: More than 2 values for advanced filtering

    Yes, and also arbitrary logic (AND, OR, NOT) the way it works in Salesforce :-)