How can we improve Power BI?

Search my filter values in a dashboard

I have 40,000 values in some of my core filters. Because the web UI only supports browsing through the filter values, I have to pre-filter each dashboard. I need the same search UI available in Excel filters.

265 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Chris Slemp (MR. SOCIAL) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • Rebecca commented  ·   ·  Flag as inappropriate

    Is there any plans for this? Adding slicers to all reports doesn't quite meet my company's reporting needs.

  • Joel Faltermeier commented  ·   ·  Flag as inappropriate

    Please add better search functions! Specifically, a simple "search" box like what is in PowerView filters by default, or in Excel when you click a column filter dropdown.

  • Peter commented  ·   ·  Flag as inappropriate

    Agreed - need the ability to search a filter based on characters entered, such that the filter selections narrow as more characters are entered. Alternative would be a text box filter (ie no check boxes) that would allow wildcards in/around the characters entered. A context example would be to facilitate selecting a part number or series of part numbers when the list itself could contain thousands of unique part number values.

  • ggorham2 commented  ·   ·  Flag as inappropriate

    What we could use in our reports is the ability to search on specific attributes from our Product catalog. Example is a simple search box filter that we can add 10 skus or 40 or 423. Advance filter lets us only search 2 values.

  • nithin commented  ·   ·  Flag as inappropriate

    Search functionality should be added for page level as well as report level filters. This is a basic functionality not sure why this was missed in the first place. Please add this feature asap

  • Anonymous commented  ·   ·  Flag as inappropriate

    I'd like to make sure this feature is still considered imperative by the developers. Our company has large datasets like many of the other commenters in this thread. We are switching over from PowerView to PowerBI and have found the lack of search functionality within filters to be a significant problem.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Some of the more diverse filters we have in our dimensions go into the 100,000's (for example, our client wants to track orders against 3 product codes). This makes filtering in front of clients slightly embarrassing to showcase, as you can imagine.

    We'd like to use this as an access tool for the semantic layer of our data marts, but we could really use a filtering search if we're going to leverage this. I can see how the current filtering works nicely with smaller datasets but when we get into big data search tools are vital.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is a very crucial function. Especially when working with large company data sets. Will this be added ASAP?

  • Ken commented  ·   ·  Flag as inappropriate

    Yes Power BI should have this. This was in Power View I am just not following how MS is missing how important such little things are that makes a company choose another tool because of such little things. Also why would power BI be a step backwards in any aspect from power View.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I agree this isn't completed. The request was to filter values IN A DASHBOARD. Advanced filtering is for a REPORT.

  • Melissa Coates commented  ·   ·  Flag as inappropriate

    Agree with need for more advanced filtering. If we're going to expand use of Power BI beyond simpler self-service into corporate/enterprise BI needs, more advanced filtering such as what Meagan described in her comment would be extremely helpful.

  • Meagan commented  ·   ·  Flag as inappropriate

    There is a difference in functionality between using contains and being able to search the filter values as we could in Power View. If I'm looking for a name and I want to search for "Jim W" because I can't remember Jim's last name is Williams, I don't want to select all Jim W's. I just need a shortcut to help me get to the one value I'm looking for.

  • Anonymous commented  ·   ·  Flag as inappropriate

    i don't understand why powerview and excel has a search pane and power bi not...
    what is the purpose of fancy reports when the filter functionality is poor... the existing solution with contains (advanced filtering) is not a good solution when you want to filter first and then select values in the filtered results. so not completed for me...

← Previous 1

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.