Skip to main content

Power BI

Planned

Search my filter values in a dashboard

Vote (381) Share
Chris Slemp (MR. SOCIAL)'s profile image

Chris Slemp (MR. SOCIAL) on 24 Feb 2015 02:58:28

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.

Administrator on 05 Jan 2016 07:23:13

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.

Comments (33)
Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Peter Seitz on 05 Jul 2020 22:55:25

RE: Search my filter values in a dashboard

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.

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:53:58

RE: Search my filter values in a dashboard

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.

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

nithin on 05 Jul 2020 22:51:17

RE: Search my filter values in a dashboard

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

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Power BI User on 05 Jul 2020 22:38:49

RE: Search my filter values in a dashboard

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.

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Power BI User on 05 Jul 2020 22:37:14

RE: Search my filter values in a dashboard

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.

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Power BI User on 05 Jul 2020 22:31:36

RE: Search my filter values in a dashboard

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

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Ken on 05 Jul 2020 22:30:30

RE: Search my filter values in a dashboard

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.

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Mohamad Zainuri on 05 Jul 2020 22:27:01

RE: Search my filter values in a dashboard

Yes, strongly agree - Search button - above the Filter BOX. Plus ToP 5 ToP 10 Top 15 Top 20

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Marco Russo on 05 Jul 2020 22:23:25

RE: Search my filter values in a dashboard

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

Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

Sharon Machlis on 05 Jul 2020 22:22:02

RE: Search my filter values in a dashboard

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