Skip to main content

Power BI

New

Dropdown Search

Vote (51) Share
c.wilkins's profile image

c.wilkins on 06 Jan 2017 04:27:10

Allow the dropdown filter to have a search box. Also, allow for all searched items to be selected at once. Essentially a select all button that only selects returned search results.

Comments (6)
c.wilkins's profile image Profile Picture

c8e9c2a9 1e21-4563-8ffb-b55cbe756280 on 06 Jul 2020 00:12:07

RE: Dropdown Search

This needs to be resolved please

c.wilkins's profile image Profile Picture

09f04485 b1e8-44ec-a1f6-c5e30ba5d1ab on 06 Jul 2020 00:07:07

RE: Dropdown Search

Would need this so often, thanks!

c.wilkins's profile image Profile Picture

29bae9c5 5041-4d89-b720-aac48cd41c96 on 06 Jul 2020 00:00:06

RE: Dropdown Search

this would be incredibly useful for numeric fields - esp pseudo-numeric fields in non-modifiable databases (e.g. "project number" - identifies as numeric, but no one's doing math on it)

c.wilkins's profile image Profile Picture

a33a5634 e4a5-4bab-bf71-b39a3b8b6ae7 on 05 Jul 2020 23:59:37

RE: Dropdown Search

if i change the filed data type from text to numeric data type, i have issue with sort order,
data is not sorting to ASC or Dec order

c.wilkins's profile image Profile Picture

942baa77 6c30-4a93-b42f-d8882edcd6c2 on 05 Jul 2020 22:59:31

RE: Dropdown Search

This is the one item that is keeping me from migrating SSRS reports to Power BI: We have parameters that are set up to return results that contain inputted text. For example: Show all titles that contain the word: Space
1. This will return all titles that containing the letters 'space' (non-case sensitive)
2. WIll allow you to 'Select All' as there may be a LOT of results that you want to see
3. This is dynamic for the user on the RS Server, NOT hardcoded in DAX

c.wilkins's profile image Profile Picture

2cc212fc 6d83-498b-bdbc-184ef0bab2f0 on 05 Jul 2020 22:57:06

RE: Dropdown Search

Please vote for same search request at this link:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15858583-slicer-search-add-select-all-results-option#comments