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

b8c3c1f0 2218-4b17-a0e8-4e61f8a5cdbc on 05 Jul 2020 23:03:12

RE: Visual level filtering in slicers

This is a strongly desired feature and fairly routine for most BI apps. Please prioritize for development.

Andre Cavaca's profile image Profile Picture

15b4ac4f bc9a-4902-a5a1-4039d3a88a65 on 05 Jul 2020 23:03:10

RE: Visual level filtering in slicers

Need this ASAP.

Andre Cavaca's profile image Profile Picture

b7399193 af44-4272-8a6a-5a58a02b588c on 05 Jul 2020 23:02:24

RE: Visual level filtering in slicers

Yes, please add this feature!

Andre Cavaca's profile image Profile Picture

b2b9291b 96ee-4d52-8079-fa49c2c6f1a8 on 05 Jul 2020 22:55:33

RE: Visual level filtering in slicers

This is a definite requently requested feature! Right now, the workaround seems to create a calculated column (with filters in it) and use it for slicer - however, it's not always elegant.

Andre Cavaca's profile image Profile Picture

efc990e1 628b-43cc-a068-09981364031d on 05 Jul 2020 22:55:29

RE: Visual level filtering in slicers

Needed badly indeed. Other competitive tools in the market do offer this sort of functionality.

Andre Cavaca's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:54:53

RE: Visual level filtering in slicers

I also consider this feature as really needed. Definitively to be addded to the priority list.

Andre Cavaca's profile image Profile Picture

763de46f 9eae-4465-bf06-bf82b4cfc672 on 05 Jul 2020 22:54:34

RE: Visual level filtering in slicers

This feature is really needed. Please add it to your priority list.

Andre Cavaca's profile image Profile Picture

83c8b39b a540-43e3-8354-cf86976626d5 on 05 Jul 2020 22:54:21

RE: Visual level filtering in slicers

Any updates on this? the previous workaround was broken in June update and still present in July.

Andre Cavaca's profile image Profile Picture

adf089a4 d0d3-405c-8910-4c30ff5061cc on 05 Jul 2020 22:53:48

RE: Visual level filtering in slicers

We really need this option so as to expose only limited options without having to change the base data.

Andre Cavaca's profile image Profile Picture

8dcd1191 0256-47e5-94cd-37cf68855e06 on 05 Jul 2020 22:53:22

RE: Visual level filtering in slicers

We need this.