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...
  • Erwin commented  ·   ·  Flag as inappropriate

    Needed badly indeed. Other competitive tools in the market do offer this sort of functionality.

  • Al commented  ·   ·  Flag as inappropriate

    This feature is really needed. Please add it to your priority list.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Any updates on this? the previous workaround was broken in June update and still present in July.

  • Anonymous commented  ·   ·  Flag as inappropriate

    We really need this option so as to expose only limited options without having to change the base data.

  • Jesper Sommer commented  ·   ·  Flag as inappropriate

    So ... it's been about a year. And while there is a "Visual level" filter on slicers now, it doesn't work (nothing can be dropped to it). When will users be able to filter data in slicers, without making it a Page level filter?

  • Wildmight commented  ·   ·  Flag as inappropriate

    This would help with custom Date filters / slicers - especially the default date/calendar slicer

  • Anonymous commented  ·   ·  Flag as inappropriate

    The Admin stated in July 2016 that this was going to be put to the BI team. It's almost been a year. When will we get this basic functionality? It is causing a lot of extra data manipulation work and headaches.

  • Pual commented  ·   ·  Flag as inappropriate

    My data source has default Year beginning with 1900. My customers would like to filter and see visuals for the last 5 years only. This feature would bring efficiency and effectiveness to Power BI as well as relevance to my customers.

  • Khusru commented  ·   ·  Flag as inappropriate

    Yes. This is very much needed. Moreover, i would be highly appreciated if thre is an option to filter data on various pages.

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.