Skip to main content

Power BI

Planned

Search my filter values in a dashboard

Vote (296) 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 (28)
Chris Slemp (MR. SOCIAL)'s profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 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

a8141d20 9b0e-4b23-8ccb-825ac7dc203a 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

823d7b8d c6d9-4978-82f9-5b6899212b98 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

f4d2790b 9dad-439f-84fc-7b52af028406 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

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

823d7b8d c6d9-4978-82f9-5b6899212b98 on 05 Jul 2020 22:08:39

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.

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

ed9423e7 ed9c-44a9-a039-fa48bb5c180d on 05 Jul 2020 22:00:11

RE: Search my filter values in a dashboard

Would like to see search in slicers

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

a2a51da5 9fb2-4067-bc47-2111bd228698 on 05 Jul 2020 21:58:57

RE: Search my filter values in a dashboard

100% agree. We're testing on some of our data and it is borderline ridiculous. We have a dim with 30k+ items in it. Then we have others with 100s. This is clearly needed asap.