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:32:50

RE: Visual level filtering in slicers

We need this visual filter for slicer where i can add date as value and other column like flag as filter to show only those dates.
Thanks

Andre Cavaca's profile image Profile Picture

Kamal Mukhi on 05 Jul 2020 23:32:29

RE: Visual level filtering in slicers

Please add this feature. We need this.

Thank You
Kamal Mukhi

Andre Cavaca's profile image Profile Picture

victor on 05 Jul 2020 23:32:18

RE: Visual level filtering in slicers

Please add this feature! Today We can add a slicer to filter another slicer, but this is totally inefficient since colateral work of editing interactions become huge and really annoying.

So, please:

1) Allow the filter a slicer
2) Improve the "edit interactions" funcionality. It would be great if we can "affect all visual", or "affect none".

Andre Cavaca's profile image Profile Picture

Alexis Olson on 05 Jul 2020 23:29:13

RE: Visual level filtering in slicers

It needs to be possible to do this based on a measure. I'd like to exclude certain options that don't meet a specific threshold.

Andre Cavaca's profile image Profile Picture

Anthony on 05 Jul 2020 23:27:58

RE: Visual level filtering in slicers

Will be very useful

Andre Cavaca's profile image Profile Picture

Chris Mlynarczyk on 05 Jul 2020 23:27:23

RE: Visual level filtering in slicers

I found a reliable workaround for this, you can basically just use a slicer on a slicer - after all, what is a slicer if not just a dynamic Visual Level Filter?

1. Create Slicer #1 for your users to interact with
2. Create Slicer #2 with the field you want to filter Slicer #1 by, i.e. the field that you would have put into your Visual Level Filter.
(Example: If Slicer #1 has names of all sales reps in the company, and you only want it to show reps in a certain region, then create Slicer #2 with the Region field. Or, if you want to manually choose specific reps to show, then you can even just use the same Sales Rep field in Slicer #2)
3. Edit the interactions on Slicer #2 so that it ONLY INTERACTS WITH SLICER #1. If necessary, edit the interactions of your other visuals to not interact with Slicer #2.
4. Choose the values on Slicer #2 that you want to allow in Slicer #1, i.e. the values that you would have allowed in the Visual Level Filter.
5. Open the View tab, check the "Selection Pane" box, find Slicer #2 on the Selection Pane, and hide it (click the eye next to it) so users can't interact with it inadvertently.

Hope this helps!
Chris

Andre Cavaca's profile image Profile Picture

Power BI User on 05 Jul 2020 23:27:17

RE: Visual level filtering in slicers

Very needed function that is missing in Power BI. We are working on the project which some functions are very complicated to implement because of a lack of filtering in slicers.

Andre Cavaca's profile image Profile Picture

Chris Mlynarczyk on 05 Jul 2020 23:26:58

RE: Visual level filtering in slicers

I just ran into this issue, but after giving it more thought, I think there's a fundamental problem with visual level filters on a slicer. How do you handle interactions between that slicer and visuals that don't have the same filter applied? E.g. say the visual contains values 1, 2, and 3, but the slicer is filtered down to values 1 and 3. What do you do with value 2 in the visual? When would Power BI display that data and when would it be filtered out?

I think the best solution is to give an option to make slicers subservient to the visuals they interact with, maybe a toggle that trims slicers down to data that's actually in the resulting visuals. I don't think allowing visual level filters on slicers properly solves the problem because it would, in the end, create a data mismatch between visuals and slicers that would be difficult to reconcile. Just my 2 cents.

Andre Cavaca's profile image Profile Picture

sunil.tak@bizmetric.com on 05 Jul 2020 23:26:53

RE: Visual level filtering in slicers

Seriously needed. If , we can get some expected dates, that will be great.

Andre Cavaca's profile image Profile Picture

Pär Adeen on 05 Jul 2020 23:26:23

RE: Visual level filtering in slicers

Please note that this request is valid for all filter visuals, not only slicers. As I'm told, visual level filters are turned of already in the development API as soon as you choose to develop a filter visual.
Please also note that using the other two filters, Page level filters and Report Level filters are already available for all filter visuals already, so why not the visual level filter as well