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,840 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...
  • Anonymous commented  ·   ·  Flag as inappropriate

    This is a pretty big must-have for our organization. Have several visuals where we only want to expose a small portion of the values to a given audience, the inability to simply add a visual-level filter to the Slicer visual is severely decreasing our efficiency when creating these reports. This seems like it should be a simple option, but instead our report engineers are stuck resorting to work-arounds that rarely justify their effort required.

    Please support this feature, cannot overstate how much time this simple fix would save our office.

  • Anonymous commented  ·   ·  Flag as inappropriate

    The ability to filter the slice directly is a critical bit. It would allow the slicer to show a subset of the whole.

  • suresh commented  ·   ·  Flag as inappropriate

    Please enable this feature asap. Our customers are eagerly waiting for this feature

  • rgoerwit commented  ·   ·  Flag as inappropriate

    Important for me as well. There are a lot of reasons why one might want to suppress slicer options without actually filtering out data. Sometimes the data one has available for a slicer is confusing to normal users of the report and should be hidden, but not eliminated from the un-sliced/un-filtered data.

  • Joe commented  ·   ·  Flag as inappropriate

    Please enable this feature. It's really silly that I can't do this.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Adding support for this feature. Really really frustrating having to make reference tables for what should be a very simple filter option for slicers.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Adding support for this feature request. Really odd why such a simple (and apparently commonly needed) feature that is supported across other visuals doesn't work here with the standard slicer.

  • martin hakansson commented  ·   ·  Flag as inappropriate

    This is a must have for me. When I connect to SSAS i have like 10 different entities to choose from, which gives me an enormous amount of possibilities when slicing. Works perfectly in Excel, so should work in Power Bi as well!?

  • Steve commented  ·   ·  Flag as inappropriate

    This is not currently available. Page-level filters can be applied, but not visual filters.

  • Laurisa Prince commented  ·   ·  Flag as inappropriate

    The slicer should be dynamic and only display relevant selections. If I have two slicers, one that filters on year, I would want the customer slicer to only display customers from that year(s) to further filter by. Subsequently or alternately, if I select customers, then I only want to see years that they bought to further my selection. It makes no sense to present the user with selections that leave all the other visuals blank. I understand due to the interactive nature of selecting items on charts, it could potentially cause conflicts between what's selected on the chart vs what's selected on slicer, but this is a constant use feature for me in a different product.

  • Michael Hawker commented  ·   ·  Flag as inappropriate

    Yeah, a lot of times you have details about a product in the list like it's release date. And you want to sort from newest to oldest as you generally query about newer items.

  • Anonymous commented  ·   ·  Flag as inappropriate

    There is a cutsom visualization called "Hierarchy Slicer" that has this functionality. You don't have to use the hierarchy aspect of the slicer if you don't need it, but the list filters down based on your other selections. This needs a permanent fix though, and I know there can be issues with custom visuals on mobile devices.

    https://app.powerbi.com/visuals/show/HierarchySlicer1458836712039

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.