Skip to main content

    Power BI

    Completed

    Visual level filtering in slicers

    Vote (2792) Share
    Andre Cavaca's profile image

    Andre Cavaca on 02 Mar 2016 03:49:41

    I have a large set of options from which I would like to pick some specific ones and use them in a slicer to filter my data.
    Currently, this is not possible while it is an implemented feature for other chart types.
    I'm currently using a 100% stacked column chart as a workaround.

    Administrator on 14 Jun 2019 04:06:20

    I'm happy to say this is now complete! In the June 2019 release of Power BI Desktop you'll see you can set visual level filters on slicers. There's one known issue where applying a measure filter to a slicer in range mode causes the visual to show an error. We'll release a fix in an interim update before the July release. Thanks for your patience and your votes, everyone!

    Comments (148)
    Andre Cavaca's profile image Profile Picture

    dd11ac42 c871-4f43-b2c4-c997ebc70490 on 05 Jul 2020 22:29:18

    RE: Visual level filtering in slicers

    Changing core-functionalities like this is very frustrating

    Andre Cavaca's profile image Profile Picture

    95dd2335 adf8-451a-add0-4bf68fcf0f9b on 05 Jul 2020 22:29:05

    RE: Visual level filtering in slicers

    I have the same problem. It is very important

    Andre Cavaca's profile image Profile Picture

    b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 22:28:49

    RE: Visual level filtering in slicers

    I didnt know it worked like that but I really like it. Please add.
    Unfortunately I havent got any votes left :(

    Andre Cavaca's profile image Profile Picture

    4cb28cce 9d7e-400f-aa91-a2b39073bf31 on 05 Jul 2020 22:28:26

    RE: Visual level filtering in slicers

    Both for getting rid of buggy members and also just creating slicers that are tuned to specific charts where you might not want to see everything, this would be excellent.

    Andre Cavaca's profile image Profile Picture

    36d39107 b51d-40a2-b344-7cb65fe5da71 on 05 Jul 2020 22:27:10

    RE: Visual level filtering in slicers

    I'd really like this (old) function ("hack"). I use this option in almost every report I create. Please put this functionality back !!

    Andre Cavaca's profile image Profile Picture

    c86e44ea 5ac5-41ab-9a46-d11f9704bde3 on 05 Jul 2020 22:27:09

    RE: Visual level filtering in slicers

    I think the best way to accomplish this is to use a visual level filter.

    Andre Cavaca's profile image Profile Picture

    6c7fa9be d1b4-449a-ab5f-844149db0781 on 05 Jul 2020 22:26:36

    RE: Visual level filtering in slicers

    Agreed! Have to use workarounds to achieve this right now... Please implement a slicer filtering option

    Andre Cavaca's profile image Profile Picture

    cddbc733 90ad-4f11-a324-fe4f6f243abc on 05 Jul 2020 22:26:28

    RE: Visual level filtering in slicers

    Ah I was wondering why this functionality was gone. It was a good hack :)

    Andre Cavaca's profile image Profile Picture

    d169d5fb d5b2-4e26-bb86-4ad0ce84163c on 05 Jul 2020 22:26:10

    RE: Visual level filtering in slicers

    I would like to chime in on this - I'm using multiple clustered column charts to work around this issue, but I would definitely like to be able to filter my slicer options.

    For example, I have ice cream in both cups and cones under the same product category 'ice cream'. I want to be able to only show relevant items (either cups or cones) in my slicer.

    Please add this back in as an official feature.. or even as a hack is fine ;)

    Andre Cavaca's profile image Profile Picture

    f0aa7ed3 aee2-4f4a-b44b-92f8c088485e on 05 Jul 2020 22:26:10

    RE: Visual level filtering in slicers

    Another idea:

    On top of putting in a visual level filter, maybe you guys can create another check box in the field. ("show items with data only").

    Currently: you have "show items with no data"