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.
Thanks for your feedbacks! We understand that advanced filter mode does not fully serve the need. We plan to add the search capability in. Stay tuned.
Ju Chen commented
There is workaround before Power BI product team create this function: by installing "Filter by List by Devscop", on Power BI Desktop extension. It can copy/past multiple values and do multiple slicer on the report. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381413?tab=Overview
David Mellinger commented
This one is needed, but this one is even more important to clients that need to paste in lists of skus\parts etc:
Please vote these up!
Is there any plans for this? Adding slicers to all reports doesn't quite meet my company's reporting needs.
Any chance this one is coming soon?
Joel Faltermeier commented
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.
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.
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.
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
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.
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.
This is a very crucial function. Especially when working with large company data sets. Will this be added ASAP?
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.
Mohamad Zainuri commented
Yes, strongly agree - Search button - above the Filter BOX. Plus ToP 5 ToP 10 Top 15 Top 20
Marco Russo (test account) commented
If you are interested in this thread, you should trySmartFilter: http://okviz.com/smart-filter/
It currently has a 1,000 item limits, but we are considering how to customize it in an upcoming release...
I agree this isn't completed. The request was to filter values IN A DASHBOARD. Advanced filtering is for a REPORT.
Peter Spruijt commented
Fully agree on this topic.
Melissa Coates commented
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.
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.
I agree. We need to be able to search the filter list as we did in PowerView.
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...