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

    7f76be23 927c-4386-8fe4-9c349963a86e 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

    c6662f6c 493f-434e-89cc-fe8bf12de05a on 05 Jul 2020 23:24:36

    RE: Visual level filtering in slicers

    Seriously needed

    Andre Cavaca's profile image Profile Picture

    63ad2013 a0fe-4afe-be62-c53c68c80a74 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

    baa8590f cfc6-414f-a10b-cef0b033827d 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

    9fabfd06 3b74-4301-b122-7702f3c14306 on 05 Jul 2020 23:24:03

    RE: Visual level filtering in slicers

    Very much needed feature

    Andre Cavaca's profile image Profile Picture

    2fe9c1c7 881e-4f4a-a9f3-f37f898b0d94 on 05 Jul 2020 23:23:19

    RE: Visual level filtering in slicers

    any update.. pls..

    Andre Cavaca's profile image Profile Picture

    2fe9c1c7 881e-4f4a-a9f3-f37f898b0d94 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

    b5588148 8109-47d1-a40d-45e5262644eb 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

    bd804941 caed-4c89-8c5b-e6640a182346 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

    Andre Cavaca's profile image Profile Picture

    15f0344b f6ba-4f82-9a5c-efb4719efdd5 on 05 Jul 2020 23:20:29

    RE: Visual level filtering in slicers

    the work-arounds are not sufficient