cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlosDash Regular Visitor
Regular Visitor

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

Accepted Solutions
Super User IV
Super User IV

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

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Highlighted
carlosDash Regular Visitor
Regular Visitor

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

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

11 REPLIES 11
Super User IV
Super User IV

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

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

carlosDash Regular Visitor
Regular Visitor

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

 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. 

Highlighted
carlosDash Regular Visitor
Regular Visitor

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

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

Dave_C Regular Visitor
Regular Visitor

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

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

vanessa Member
Member

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

@Dave_C

It works when you use list and not dropdown.

Anonymous
Not applicable

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

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

Kinsey Frequent Visitor
Frequent Visitor

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

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

descon Frequent Visitor
Frequent Visitor

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

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.
Krampis Frequent Visitor
Frequent Visitor

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

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors