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 (32)
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.
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.
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.
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...
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.
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
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.
RE: Search my filter values in a dashboard
Yes please, searching of filters is a must
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
RE: Search my filter values in a dashboard
This really is still not good enough. It's the one area that lets PowerBI badly down. The rest is great
Loading, cleansing etc. Wonderful. Measures and visually is also first rate. But filters and searching is poor.
It's even miles behind Excel.