Skip to main content

Power BI

Needs Votes

add wildcard field search box to Dashboard filters and filter drop downs

Vote (160) Share
Craig Mitchell's profile image

Craig Mitchell on 26 Mar 2015 10:07:17

Need ability to place a filter box on a dashboard that allows wildcard text search of a defined text field. e.g. product description, type 'coca' and get all items with coca in description, then select one or multiple items.
Filter drop downs instead of slicer boxes would provide more space for charts.
this idea is addition functionality to one already posted http://support.powerbi.com/forums/265200-power-bi/suggestions/6674820-global-filter-in-dashboards

Comments (14)
Craig Mitchell's profile image Profile Picture

d41fd652 3cc7-ea11-a812-000d3a9b112e on 15 Aug 2020 08:42:34

RE: add wildcard field search box to Dashboard filters and filter drop downs

I propose those wildcards:
Sale !Sales for Sale but not Sales (! instead -)
"Sale" for exact whole word Sale
xxx* for starting with xxx
*xxx for ending with xxx
*xxx*yyy* for containing xxx and yyy (no matter in what order)
x?y for xay, xby, x1y, x2y, .... but not xaby
x#y for x1y, x2y, ....
x&y for xay, xby, ....

Craig Mitchell's profile image Profile Picture

65c88a40 2a5b-4b65-9906-a3d11145690d on 05 Jul 2020 23:35:03

RE: add wildcard field search box to Dashboard filters and filter drop downs

...or even just allow the standard '*' and '?' wildcards within the existing search box that Slicers/Filters have.

Craig Mitchell's profile image Profile Picture

20b5236e e6b3-4238-a407-254e2a1bb296 on 05 Jul 2020 23:24:16

RE: add wildcard field search box to Dashboard filters and filter drop downs

Need the same functionality for slicers.

Craig Mitchell's profile image Profile Picture

4c3ae33f 48b2-4ca9-80c7-49d6721de7e4 on 05 Jul 2020 22:59:27

RE: add wildcard field search box to Dashboard filters and filter drop downs

need this otherwise no choice but to use Tableau

Craig Mitchell's profile image Profile Picture

8314545c 7be4-444c-8a31-c02d8ed02ed9 on 05 Jul 2020 22:43:22

RE: add wildcard field search box to Dashboard filters and filter drop downs

If the current filter could be modified to have the search feature instead of the drop down or tick boxes from the off set - rather than having to click into it on the mobile app, that would be great

Craig Mitchell's profile image Profile Picture

0914daa6 fbf5-4345-bd82-3c4518b154b4 on 05 Jul 2020 22:38:45

RE: add wildcard field search box to Dashboard filters and filter drop downs

this must we need and user login roles also we need

Craig Mitchell's profile image Profile Picture

075c9809 dee2-4809-8cdb-8aa788137f61 on 05 Jul 2020 22:35:49

RE: add wildcard field search box to Dashboard filters and filter drop downs

This is a must in order to launch Power BI to the enterprise. Filters are not enough. Without this the business will push for tableau

Craig Mitchell's profile image Profile Picture

53184f56 bb39-4361-bac2-65eb7b7907ff on 05 Jul 2020 22:25:45

RE: add wildcard field search box to Dashboard filters and filter drop downs

Just started playing with Power BI linked to our SSAS Cubes, this feature would be great.

Craig Mitchell's profile image Profile Picture

92c9b236 0484-4c3e-ab86-12ce4dc589c0 on 05 Jul 2020 22:25:18

RE: add wildcard field search box to Dashboard filters and filter drop downs

Please BI Team... this is VERY important! It has been more than a year since Craig initial suggestion. Any update?

Craig Mitchell's profile image Profile Picture

f3c77f05 d04b-4aee-81f7-98a338d511e6 on 05 Jul 2020 22:25:01

RE: add wildcard field search box to Dashboard filters and filter drop downs

YES Please! Very important for users searching for the needles in million row haystacks