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 Spruijt on 05 Jul 2020 22:13:50

RE: Search my filter values in a dashboard

Fully agree on this topic.

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

Melissa Coates on 05 Jul 2020 22:12:54

RE: Search my filter values in a dashboard

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.

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

Meagan on 05 Jul 2020 22:12:51

RE: Search my filter values in a dashboard

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.

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

Brian brian.pitera@owenscorning.com on 05 Jul 2020 22:12:49

RE: Search my filter values in a dashboard

I agree. We need to be able to search the filter list as we did in PowerView.

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

Power BI User on 05 Jul 2020 22:12:46

RE: Search my filter values in a dashboard

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

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

Power BI Ideas Admin on 05 Jul 2020 22:10:03

RE: Search my filter values in a dashboard

'@Julie Zhu friendly heads up. Most of us don't consider this an acceptable solution. Please see the comments below.

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

Power BI User on 05 Jul 2020 22:09:08

RE: Search my filter values in a dashboard

Advanced filter mode still doesn't fulfill the need. If I want search based on certain criteria and apply filter on large volume of data this doesn't help. In short it would be great if we have a search option for filter

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

Robert J on 05 Jul 2020 22:09:06

RE: Search my filter values in a dashboard

I demoed Power BI to one potential user. Not impressed with searching and filtering. I'm really at a lost to understand how they felt this rubbish solution is suitable. It's obvious what's needed. A good starting point only is Excel.

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

gary on 05 Jul 2020 22:09:03

RE: Search my filter values in a dashboard

Yes please, searching of filters is a must

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

Power BI Ideas Admin on 05 Jul 2020 22:08:39

RE: Search my filter values in a dashboard

This is NOT COMPLETE. This does not function as requested. Please make filters searchable from the report page itself. Come on guys