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.
Andre Cavaca
shared this idea
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!
145 comments
-
Fred Kaffenberger
commented
Great news to hear that this is a known issue with a fix on the way! Just ran into this one today. Thank you!
The error is "primary projections must have set equality with the corresponding subset in the filter target."
-
Erwin
commented
I second this: When will this be available for the Power BI Report Server version?
-
Anonymous
commented
When will this be available for the Power BI Report Server version?
-
Marco Russo (test account)
commented
Hey Will, unfortunately the votes will now move to the new filter experience that has the same problem!
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37877170-customize-visible-items-in-new-filter-experience -
Abhijith DSouza
commented
Here is my solution which does the trick for now
-
Anonymous
commented
What do you mean "enabling filters again soon"?
-
Mike Carlo commented
Here is a clunky work around.. it requires the use of an additional Page in the report for "Settings".. not ideal but for now it will help...
-
Maybe you could leverage some MVPs to work out this solution????
-
Vikram
commented
There are 100 categories in my list and I need to select only the top 10/15 for my Slicer. And this top 10/15 keeps changing every month. So I need to be able to dynamically select the top 10 categories in my Slicer so that I can then select a Single category and do multiple analyses on that.
-
Alejandro
commented
Men!! This is a must
-
Anonymous
commented
Update please
-
cmihiripenna
commented
We need visuals level filters for slicers. This is long waiting. No positive response yet.
-
Philip Usher
commented
Please allow users to custom sort any chart or table. The workaround of joining a column with another table including sort order is long winded and inefficient. PowerBI should ensure it covers all the basic functionality available in Excel - if you made it more Excel-like it would absolutely smash the competition.
-
Anonymous
commented
Assigning a default value is required in a drop down menu..
-
Darryl Dsouza
commented
2 years and over 3000 votes.
When would this idea take priority?
Or any other updates will be handy too. -
mmilirud
commented
Very much needed. Sometimes I need to filter most of the content on the page by a specific filter, but then one or two shouldn't be covered. Since we don't have group filters, visual filters is the next best thing. Today I'm forced to split such elements across multiple pages.
-
Anonymous
commented
This would be very useful.
-
SJR
commented
This is a must have!
-
Karl Geiger
commented
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.
-
Ben Sanders
commented
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?