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,526 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andre Cavaca shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    135 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Darryl Dsouza commented  ·   ·  Flag as inappropriate

        2 years and over 3000 votes.
        When would this idea take priority?
        Or any other updates will be handy too.

      • mmilirud commented  ·   ·  Flag as inappropriate

        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.

      • Karl Geiger commented  ·   ·  Flag as inappropriate

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

        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?

      • Andrew Lindner commented  ·   ·  Flag as inappropriate

        Waiting for this. Have had to do very clunky search-feature workarounds that involves typing out each value in the search bar for each value from a filtered list, rather than having a simple button that has a bookmarked visual level filter for the slicer.

      • Jeo Varghese commented  ·   ·  Flag as inappropriate

        This functionality will be really helpful. especially when we have a Drillthrough to a report + additional filtering in that report

      • Line commented  ·   ·  Flag as inappropriate

        In our customer slicer we have 300.000 customer. If I could set a filer on a country (another dimension) the sales reps would only see their customers in their country. I could do the same if I enable both-way-filtering, but i dont want to do this do to performance issue. This is a feature that exist in Qlik Sense, which our end-user is asking for.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We need this visual filter for slicer where i can add date as value and other column like flag as filter to show only those dates.
        Thanks

      • victor commented  ·   ·  Flag as inappropriate

        Please add this feature! Today We can add a slicer to filter another slicer, but this is totally inefficient since colateral work of editing interactions become huge and really annoying.

        So, please:

        1) Allow the filter a slicer
        2) Improve the "edit interactions" funcionality. It would be great if we can "affect all visual", or "affect none".

      • Alexis Olson commented  ·   ·  Flag as inappropriate

        It needs to be possible to do this based on a measure. I'd like to exclude certain options that don't meet a specific threshold.

      • Chris Mlynarczyk commented  ·   ·  Flag as inappropriate

        I found a reliable workaround for this, you can basically just use a slicer on a slicer - after all, what is a slicer if not just a dynamic Visual Level Filter?

        1. Create Slicer #1 for your users to interact with
        2. Create Slicer #2 with the field you want to filter Slicer #1 by, i.e. the field that you would have put into your Visual Level Filter.
        (Example: If Slicer #1 has names of all sales reps in the company, and you only want it to show reps in a certain region, then create Slicer #2 with the Region field. Or, if you want to manually choose specific reps to show, then you can even just use the same Sales Rep field in Slicer #2)
        3. Edit the interactions on Slicer #2 so that it ONLY INTERACTS WITH SLICER #1. If necessary, edit the interactions of your other visuals to not interact with Slicer #2.
        4. Choose the values on Slicer #2 that you want to allow in Slicer #1, i.e. the values that you would have allowed in the Visual Level Filter.
        5. Open the View tab, check the "Selection Pane" box, find Slicer #2 on the Selection Pane, and hide it (click the eye next to it) so users can't interact with it inadvertently.

        Hope this helps!
        Chris

      • Anonymous commented  ·   ·  Flag as inappropriate

        Very needed function that is missing in Power BI. We are working on the project which some functions are very complicated to implement because of a lack of filtering in slicers.

      ← Previous 1 3 4 5 6 7

      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.