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

    Robert Wolf on 05 Jul 2020 23:25:19

    RE: Visual level filtering in slicers

    very needed creates a lot of seemingly unnecessary labor to get around this seemingly simple solution. Though I have a feeling for Microsoft it is harder than it would seem.

    Andre Cavaca's profile image Profile Picture

    Ramóna Gáspár on 05 Jul 2020 23:24:54

    RE: Visual level filtering in slicers

    Our slicer is full of unnecessary data without this function, unusable, please do some development!

    Andre Cavaca's profile image Profile Picture

    Colin Giles on 05 Jul 2020 23:24:36

    RE: Visual level filtering in slicers

    Seriously needed

    Andre Cavaca's profile image Profile Picture

    VG on 05 Jul 2020 23:24:21

    RE: Visual level filtering in slicers


    I support the request. This functionality is very necessary for those of us who migrate our Excel reports to Power BI

    Andre Cavaca's profile image Profile Picture

    Narayana Power BI User on 05 Jul 2020 23:24:20

    RE: Visual level filtering in slicers

    To make this feature really powerful, please also add the ability to add a measure as a visual level filter just like can be done for regular visuals and charts.

    Andre Cavaca's profile image Profile Picture

    vishnu on 05 Jul 2020 23:24:03

    RE: Visual level filtering in slicers

    Very much needed feature

    Andre Cavaca's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:23:19

    RE: Visual level filtering in slicers

    any update.. pls..

    Andre Cavaca's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:23:19

    RE: Visual level filtering in slicers

    i think, my company should look towards tableau..

    Andre Cavaca's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:22:10

    RE: Visual level filtering in slicers

    Very much needed feature. I am using Direct Query mode and hence cannot make a workaround of calculated Table. Another workaround of hiding a slicer behind another slicer works if u know what values need to be selected. But for me i need TOP 10 values, displayed in Slicer which is dynamic and in direct Query.

    It will be good to connect a slicer with a visual and display the values in that visual, an another Idea.

    Andre Cavaca's profile image Profile Picture

    Marius Sveen on 05 Jul 2020 23:21:29

    RE: Visual level filtering in slicers

    Hi,
    Would be great if we could filter slicers with measures as well.

    test = COUNT ( 'test'[test] )

    Then put the "test" measure in visual filter and say you only want to show >= 1