cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlosDash
Advocate IV
Advocate IV

Is there a way to input TEXT to filter results in "Report" view?

I'd like to display a table with a few columns (FirstName, LastName, D.O.B, Comments, EntryDate etc.). In the desktop editor, I can easily add "include" and "exclude" type of "Advanced filters" to target a certain person or persons. 

 

Is it possible to create a filter in the report view so that a user can input text queries to filter data?

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

I do not believe that this is included in slicer functionality as you describe it. But, slicers might be the answer to your issue depending on your requirements.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

carlosDash
Advocate IV
Advocate IV

I actually found the feature I was looking for in the "Slicer"-visualization filter!

 

Create a slicer and choose which column you want to use. Then click the three little dots in the right hand corner and choose "Search". Now you can easily find the entry by typing it in the search field. 

 

PBIDesktop_2017-01-23_17-34-50.png

 

 

View solution in original post

13 REPLIES 13
Krampis
Regular Visitor

There is a Text Filter custom visual which allows text search by part of text as well as using * wildcard.

Anonymous
Not applicable

Text Filter just doesnt work at all with other charts on the visual. 

MBresnan
Frequent Visitor

if you couple that custom text filter visualization with a slicer, it works even better, if you are looking to trim down the possible choices with the text filter. 

carlosDash
Advocate IV
Advocate IV

I actually found the feature I was looking for in the "Slicer"-visualization filter!

 

Create a slicer and choose which column you want to use. Then click the three little dots in the right hand corner and choose "Search". Now you can easily find the entry by typing it in the search field. 

 

PBIDesktop_2017-01-23_17-34-50.png

 

 

View solution in original post

Yes, this solution is Valid but it is applicable only for Text type of Fields like Full Name, Type of Product,etc .But for fields like ID's/Date's this type of Search is not Possible.

 

I dont see that option to choose the search option on the slicer.  do I need to turn it on somewhere?

@Dave_C

It works when you use list and not dropdown.

descon
Regular Visitor

It works when it is a drop down too. After selecting 'Search', you need to use the down arrow to view the values and the first one will now be the search line. I found it sometimes does not show if the slicer box is not wide enough.
Anonymous
Not applicable

It should work the same for a drop down (see pic). Though I have a few suggestions to improve this feature:

1) Make this box bigger or allow users to adjust the size. It is hard for novice users to find this feature.

2) Be able to type in the filter's box instead of having to click the down arrow first.

3) Allow developers to set it to match the beginning of the string, not just whether the item contains the entered text. 

 

image.png

There is a generic 'Text Filter' in the store now which looks like it resolves all this now

Many Thanks ! 🙂
exactly what i was looking for !

Greg_Deckler
Super User
Super User

I do not believe that this is included in slicer functionality as you describe it. But, slicers might be the answer to your issue depending on your requirements.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

 Thank you for your reply. Essentially I'd need an input text field where the user could type search parameters but I'm guessing this is not possible at the moment in Power BI. I've looked into slicers but they don't offer the functionality that I'm after. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!