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 (149)
    Andre Cavaca's profile image Profile Picture

    Tobias Dirksen on 05 Jul 2020 22:29:18

    RE: Visual level filtering in slicers

    This is a must-have!

    Andre Cavaca's profile image Profile Picture

    Tobias Dirksen 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

    Power BI User 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

    Mike 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

    Brian Grant 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

    Wouter Zijlstra 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

    rlansing 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

    Power BI User 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

    Jay Killeen 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

    David 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 ;)