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

9d234818 84bf-430c-ab63-e62a0c95c150 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

1fb034c5 e4df-418d-81d1-32854a4ea714 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

14f7de74 94a6-4e79-800f-b9ec7c25da2f 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

437dd512 43da-4e8b-a157-47f5a574f17c on 05 Jul 2020 23:36:16

RE: Visual level filtering in slicers

A must have...

Andre Cavaca's profile image Profile Picture

c3424612 c2fc-49d6-8068-818bc05c80d9 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

33e5dd33 9ed1-4ed3-a264-bc2a39bcf7a9 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

d487a43c 4c37-4437-80fb-cf4da5742fb2 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

b2bf64b6 765f-42ce-a61d-e7450cab37c6 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.

Andre Cavaca's profile image Profile Picture

6cb43679 abb4-4ac4-9089-14b0089035cb 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