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

Power BI User on 05 Jul 2020 23:38:50

RE: Visual level filtering in slicers

This would be very useful.

Andre Cavaca's profile image Profile Picture

SJR on 05 Jul 2020 23:37:51

RE: Visual level filtering in slicers

This is a must have!

Andre Cavaca's profile image Profile Picture

Karl Geiger on 05 Jul 2020 23:37:11

RE: Visual level filtering in slicers

This would be very helpful, especially in the case where one could specify for example a "from" and "to" field towards the visual filter. There are certain use cases where for example where I would like to apply page slicer selection to all visuals, but on a certain visual I would like to allow the user to select a range until (within the range of the main slicer selection). Important for dates for the most part.

Andre Cavaca's profile image Profile Picture

Ben Sanders on 05 Jul 2020 23:37:07

RE: Visual level filtering in slicers

This is number 8 of the top 10 most voted ideas, with the last note back in January that it was under consideration... When are we going to get an update?

Andre Cavaca's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:16

RE: Visual level filtering in slicers

A must have...

Andre Cavaca's profile image Profile Picture

Andrew Lindner on 05 Jul 2020 23:36:05

RE: Visual level filtering in slicers

Waiting for this. Have had to do very clunky search-feature workarounds that involves typing out each value in the search bar for each value from a filtered list, rather than having a simple button that has a bookmarked visual level filter for the slicer.

Andre Cavaca's profile image Profile Picture

Jeo Varghese on 05 Jul 2020 23:35:38

RE: Visual level filtering in slicers

This functionality will be really helpful. especially when we have a Drillthrough to a report + additional filtering in that report

Andre Cavaca's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:35:34

RE: Visual level filtering in slicers

Is there an ETA for when this will be included? The idea has been out there for over 2.5 years.

Andre Cavaca's profile image Profile Picture

Daniel Nilsson on 05 Jul 2020 23:34:43

RE: Visual level filtering in slicers

This really has to be prioritized soon! This is a must have!

Andre Cavaca's profile image Profile Picture

Line on 05 Jul 2020 23:32:59

RE: Visual level filtering in slicers

In our customer slicer we have 300.000 customer. If I could set a filer on a country (another dimension) the sales reps would only see their customers in their country. I could do the same if I enable both-way-filtering, but i dont want to do this do to performance issue. This is a feature that exist in Qlik Sense, which our end-user is asking for.