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

    01f344b1 89ea-4ca2-ba71-ad6695c6ce87 on 05 Jul 2020 22:44:02

    RE: Visual level filtering in slicers

    Must have for me as well

    Andre Cavaca's profile image Profile Picture

    f570df02 070c-4af2-becf-5e8d06dd192f on 05 Jul 2020 22:43:13

    RE: Visual level filtering in slicers

    Please enable this feature asap. Our customers are eagerly waiting for this feature

    Andre Cavaca's profile image Profile Picture

    70855734 7b38-4a8e-9163-b4e0c5f41433 on 05 Jul 2020 22:42:27

    RE: Visual level filtering in slicers

    Please give this a high priority!

    Andre Cavaca's profile image Profile Picture

    cdb1bcc8 5098-46da-8efc-79d1aca1a158 on 05 Jul 2020 22:42:06

    RE: Visual level filtering in slicers

    Please enable this feature

    Andre Cavaca's profile image Profile Picture

    4ef379c6 c03e-443c-8150-e73bd00593ab on 05 Jul 2020 22:41:17

    RE: Visual level filtering in slicers

    Important for me as well. There are a lot of reasons why one might want to suppress slicer options without actually filtering out data. Sometimes the data one has available for a slicer is confusing to normal users of the report and should be hidden, but not eliminated from the un-sliced/un-filtered data.

    Andre Cavaca's profile image Profile Picture

    3fbae2a2 d951-4993-a4a9-6fba12787813 on 05 Jul 2020 22:40:22

    RE: Visual level filtering in slicers

    Please enable this feature. It's really silly that I can't do this.

    Andre Cavaca's profile image Profile Picture

    323b9109 cadf-4850-9945-b3fcafc9258d on 05 Jul 2020 22:38:33

    RE: Visual level filtering in slicers

    Adding support for this feature. Really really frustrating having to make reference tables for what should be a very simple filter option for slicers.

    Andre Cavaca's profile image Profile Picture

    b20d748e 47fd-449e-aee9-5a808de5f0d0 on 05 Jul 2020 22:36:22

    RE: Visual level filtering in slicers

    yes filter slicers!!!

    Andre Cavaca's profile image Profile Picture

    323b9109 cadf-4850-9945-b3fcafc9258d on 05 Jul 2020 22:36:03

    RE: Visual level filtering in slicers

    Adding support for this feature request. Really odd why such a simple (and apparently commonly needed) feature that is supported across other visuals doesn't work here with the standard slicer.

    Andre Cavaca's profile image Profile Picture

    f5e57bbc e919-4d93-9f32-71a27c8fe7cd on 05 Jul 2020 22:35:23

    RE: Visual level filtering in slicers

    This is a must have for me. When I connect to SSAS i have like 10 different entities to choose from, which gives me an enormous amount of possibilities when slicing. Works perfectly in Excel, so should work in Power Bi as well!?