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

a2a849a6 336a-467e-8016-176ffd0c74d8 on 05 Jul 2020 23:11:55

RE: Visual level filtering in slicers

essential functionality

Andre Cavaca's profile image Profile Picture

82ff19b1 1abb-4eba-84fb-b34debbd242f on 05 Jul 2020 23:11:28

RE: Visual level filtering in slicers

Yes, please add this feature to the slicer, it would make things so much easier, plus your competition, i.e. Tableau is able to do this fairly easily.

Andre Cavaca's profile image Profile Picture

513e4457 f1d4-e911-a996-000d3a4f3343 on 05 Jul 2020 23:10:54

RE: Visual level filtering in slicers

Appreciate it if you could make this priority as this is inconsistent and extremely frustrating. Thank you...

Andre Cavaca's profile image Profile Picture

a0182df9 7a75-410b-9366-6ff627f3a5fc on 05 Jul 2020 23:10:36

RE: Visual level filtering in slicers

This could be one of the most basic functions that needs to be implemented.

Andre Cavaca's profile image Profile Picture

af0019aa 9a7e-4776-9021-7b1171cd13bc on 05 Jul 2020 23:09:32

RE: Visual level filtering in slicers

My workaround is to hide another Slicer (the "pre-Slicer") behind the required Slicer. But it's clunky and easy to forget about when messing with Interactions.

I'm struggling to see the difficulty in implementing this - isnt it just: "Make Slicers consistent with the Visual Level Filter functionality of every other visual".

For prioritization, I would've gladly traded this for the Ribbon Chart (several times over!), even if that had a Y Axis ...

Andre Cavaca's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:09:18

RE: Visual level filtering in slicers

Madness this isn't available yet. Lost count at how many times I have had to put page levels filters on to get around the issue. Unfortunately, It constrains the rest of the visuals, tables, slicers, etc on the page

Andre Cavaca's profile image Profile Picture

f6da313b 744a-49c2-9492-aa97e79b3414 on 05 Jul 2020 23:09:16

RE: Visual level filtering in slicers

ç'est très importante, ferez-vous ça svp

Andre Cavaca's profile image Profile Picture

3d16b883 7a55-4d93-a561-fae90357a253 on 05 Jul 2020 23:07:23

RE: Visual level filtering in slicers

Yes, this is a big pain for a solution that I am working on. Need to filter out options in slicers, in particular "Blank" values.

Andre Cavaca's profile image Profile Picture

9b797de1 8a91-4085-b5ae-712599f0879b on 05 Jul 2020 23:06:51

RE: Visual level filtering in slicers

Agreed. This is very important.

Andre Cavaca's profile image Profile Picture

5e51c5d1 a5ba-48a6-8a57-8c3ab9a4b6a3 on 05 Jul 2020 23:06:09

RE: Visual level filtering in slicers

This is a much needed feature for Power Bi. Update this ASAP.