How can we improve Power BI?

← Power BI Ideas

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,788 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Andre Cavaca shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminWill Thompson (Product Manager, Power BI, Microsoft Power BI) responded  · 

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!

Show previous admin responses (2)

148 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    I'm not so happy. In slicers, there should be an ability to "Select All Filtered" instead of "Select All" which selects ALL values including ones which are not filtered? An example: I have 10,000 patients each with a diagnosis. If I filter on specific types of diagnosis I get a subset of the patients relevant for those diagnosis'. Naturally. So Far So Good. HOWEVER, if I want to then see which other diagnosis' are relevant for that subset of patients, I cannot instead choose just those patients in the relevant Patient Slicer, it selects ALL. And I obviously cannot individually click/select on each filtered patient due to their number?

  • Sunil Tak commented  ·   ·  Flag as inappropriate

    This is not suffice the actual issue. I need to set the current year as default year for my drop down. Which, i think, currently not possible. User can select past years or future years if required but default should be current year only. If this is possible then please provide me steps to achieve the same.

  • Fred Kaffenberger commented  ·   ·  Flag as inappropriate

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

    I second this: When will this be available for the Power BI Report Server version?

  • Vikram commented  ·   ·  Flag as inappropriate

    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.

  • Philip Usher commented  ·   ·  Flag as inappropriate

    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.

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

← Previous 1 3 4 5 6 7 8

Power BI Ideas: Reports

Categories

Feedback and Knowledge Base

(thinking…)

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.