How can we improve Power BI?

Visual level filtering in slicers

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.

2,839 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Andre Cavaca shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

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!

144 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Greg Galloway commented  ·   ·  Flag as inappropriate

    Filtering by a measure would be awesome. This would let me have one slicer on the Product table and have it crossfilter the Stores slicer based upon a sales measure. Otherwise, it's hard to crossfilter slicers that are in different tables.

  • Karl Fasick commented  ·   ·  Flag as inappropriate

    When looking for exceptions in data I am trying to present the top 10 in a slicer for the purpose of interactively turning them off. If we could have a slicer/toggle column in the table view that would work great for lots of purposes I think. Especially if a sort/helper column could be hidden if needed. Trying to think of a workaround and maybe I'll have to create identical pages with page filters and toggle between pages.

  • Mike commented  ·   ·  Flag as inappropriate

    I didnt know it worked like that but I really like it. Please add.
    Unfortunately I havent got any votes left :(

  • Brian Grant commented  ·   ·  Flag as inappropriate

    Both for getting rid of buggy members and also just creating slicers that are tuned to specific charts where you might not want to see everything, this would be excellent.

  • Wouter Zijlstra commented  ·   ·  Flag as inappropriate

    I'd really like this (old) function ("hack"). I use this option in almost every report I create. Please put this functionality back !!

  • Anonymous commented  ·   ·  Flag as inappropriate

    Agreed! Have to use workarounds to achieve this right now... Please implement a slicer filtering option

  • Micah commented  ·   ·  Flag as inappropriate

    Another idea:

    On top of putting in a visual level filter, maybe you guys can create another check box in the field. ("show items with data only").

    Currently: you have "show items with no data"

  • David commented  ·   ·  Flag as inappropriate

    I would like to chime in on this - I'm using multiple clustered column charts to work around this issue, but I would definitely like to be able to filter my slicer options.

    For example, I have ice cream in both cups and cones under the same product category 'ice cream'. I want to be able to only show relevant items (either cups or cones) in my slicer.

    Please add this back in as an official feature.. or even as a hack is fine ;)

  • Rachel Dyer commented  ·   ·  Flag as inappropriate

    You used to be able to filter a slicer by changing it into a table, filtering it, then changing it back into a slicer. Now you can't do that. That was really handy, I used it all the time. Any substitute?

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.