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

d7a61cc1 bb80-480e-8e11-17e5465121a1 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

1463699d da1b-4569-a71d-f4ed129c4d09 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

cb4ea5f4 3e16-44df-9d7b-70c1f38c3d0b 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

3f22f54c 2e70-4e21-b4bc-9dcd79a4f87d 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

5ef09d6c 5662-44ac-b885-026a47bd379b 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.

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

1edec6bb 287f-47ae-b4a1-bc25bf486f5a 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

6852ed5a ca53-4c16-9370-c627dd20b7b2 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

79ec61ca cf1e-4ccf-86e6-128f9280cc10 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

f62f7b74 2405-4796-96f7-a5cd5a89e702 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

704ab4d5 50ff-4a65-8b26-3a88b81ad66b 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...