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.
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!
Colin Giles commented
I support the request. This functionality is very necessary for those of us who migrate our Excel reports to Power BI
To make this feature really powerful, please also add the ability to add a measure as a visual level filter just like can be done for regular visuals and charts.
Very much needed feature
i think, my company should look towards tableau..
any update.. pls..
Very much needed feature. I am using Direct Query mode and hence cannot make a workaround of calculated Table. Another workaround of hiding a slicer behind another slicer works if u know what values need to be selected. But for me i need TOP 10 values, displayed in Slicer which is dynamic and in direct Query.
It will be good to connect a slicer with a visual and display the values in that visual, an another Idea.
Marius Sveen commented
Would be great if we could filter slicers with measures as well.
test = COUNT ( 'test'[test] )
Then put the "test" measure in visual filter and say you only want to show >= 1
the work-arounds are not sufficient
Please please please!!!
Arjan Fraaij commented
I voted yes on this subject needed but also Always have my thougts on when a customer is requesting this..
Most of the times they don't want to see blanks, that okay If you could filter don't show blanks, all other also the maybe new data will be shown....
Only I do see when this is available they will also start setting filters on only showing specific values in a filter. Simple only select Yes and No, what if value "Maybe" whould come in and because nobody knows any more what filters are set this will never show..
Page level or report level filters are easy found but keep having diffculties when some made there more Excel like report in Power BI with multiple slicers and start setting all kind of visualization filters.... where to look?
Having an option to show only relative values would be amazing!!!
Kelly Dittmar commented
There must be something that we're all missing which makes this tough based on the 1,387 votes for this idea since March. Will - Can you share what makes this so difficult that it was excluded from the slicer when it was first deployed?
Christer Karlsson commented
Could you also add functionality to allow AND filtering. This means for me that the filter result set is REDUCED to records matching all of the selected slicer items.
This becomes useful when you want to identify records meeting common characteristics in a slicer.
this functionality is essential
Scott Powell commented
I would suggest - not only do we need to be able to filter the list of values that show up in a slicer, but also we need to be able to optionally select default values. Looks like this idea was created in 2016...time to get on it...
It is very critical to have this option for the slicer visual!!!
This is LLLLOOOOONNNNNNGGGGGG overdue, and should be prioritised.
Dillon Farrar commented
It has been TWO YEARS