Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (164) 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

Arie Saraf 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

jeffrey Weir 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

Samrat Vangari 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

IT 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

Tom Scragg 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

Power BI User 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

Power BI User 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

Shaun Williams 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

Marcela Lozano 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

Power BI User 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