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

    Gabriel Tasiopoulos on 05 Jul 2020 22:53:22

    RE: Visual level filtering in slicers

    We need this.

    Andre Cavaca's profile image Profile Picture

    Adam Power BI User on 05 Jul 2020 22:52:59

    RE: Visual level filtering in slicers

    Please add ASAP. I second @Lars-O comments.

    Andre Cavaca's profile image Profile Picture

    Jesper Sommer on 05 Jul 2020 22:52:13

    RE: Visual level filtering in slicers

    So ... it's been about a year. And while there is a "Visual level" filter on slicers now, it doesn't work (nothing can be dropped to it). When will users be able to filter data in slicers, without making it a Page level filter?

    Andre Cavaca's profile image Profile Picture

    Wildmight on 05 Jul 2020 22:50:22

    RE: Visual level filtering in slicers

    This would help with custom Date filters / slicers - especially the default date/calendar slicer

    Andre Cavaca's profile image Profile Picture

    Raoul Töller on 05 Jul 2020 22:50:03

    RE: Visual level filtering in slicers

    Want to disable values that dont have data (for example year 2019)

    Andre Cavaca's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:49:28

    RE: Visual level filtering in slicers

    The Admin stated in July 2016 that this was going to be put to the BI team. It's almost been a year. When will we get this basic functionality? It is causing a lot of extra data manipulation work and headaches.

    Andre Cavaca's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:49:19

    RE: Visual level filtering in slicers

    Essential

    Andre Cavaca's profile image Profile Picture

    Pual on 05 Jul 2020 22:49:12

    RE: Visual level filtering in slicers

    My data source has default Year beginning with 1900. My customers would like to filter and see visuals for the last 5 years only. This feature would bring efficiency and effectiveness to Power BI as well as relevance to my customers.

    Andre Cavaca's profile image Profile Picture

    John on 05 Jul 2020 22:49:00

    RE: Visual level filtering in slicers

    Need ASAP

    Andre Cavaca's profile image Profile Picture

    Rafael Baleche on 05 Jul 2020 22:48:58

    RE: Visual level filtering in slicers

    This way we could make the most of the canvas with visuals, using only the indispensable slicers.