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,838 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

    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  ·   ·  Flag as inappropriate

    Hi,
    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

  • Arjan Fraaij commented  ·   ·  Flag as inappropriate

    Hi All,

    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?

  • Kelly Dittmar commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Scott Powell commented  ·   ·  Flag as inappropriate

    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...

    Scott

  • Dian commented  ·   ·  Flag as inappropriate

    It is very critical to have this option for the slicer visual!!!

  • Max commented  ·   ·  Flag as inappropriate

    Yes, please add this feature to the slicer, it would make things so much easier, plus your competition, i.e. Tableau is able to do this fairly easily.

  • cameronn commented  ·   ·  Flag as inappropriate

    Appreciate it if you could make this priority as this is inconsistent and extremely frustrating. Thank you...

  • Anonymous commented  ·   ·  Flag as inappropriate

    This could be one of the most basic functions that needs to be implemented.

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.