Manual input text box that can be used as a slicer to exclude data

[Shpongle]

Hi all,

I have a report that deals with support request ticket data. I presently have slicers that allow me to choose the customer, the time period and the "ticket types" that will be included in the reports.

Sometimes, there are tickets that I want to exclude from being in the results based on the language in the subject of the ticket.

As an example, Let's say I select Company A from Jan to present and it shows that there are 450 tickets. It shows me all the categories and how many tickets are in each of the categories.

If I drill down on one category and look at the tickets, I might find that there are some tickets that were automatically created by the system that I want to exclude.

Let's say for example that I want to exclude any tickets that contain the words "Auto Response" in the subject of the ticket, as there may be 70 tickets that contain this phrase that are skewing my metrics.

What I would like is an open text field on my main page that has all the control slicers, and I can enter "Auto Response" into that field and the results will slim down to the number of tickets that don't have "Auto Response" in the subject. It would be even cooler if I could use commas to separate different values that I want to exclude. If it were just a handful of specific phrases that I wanted to exclude, I would just set that up when I set up the tables. Unfortunately, the word(s) that we would want to filter will be quite varied and will have to be manually validated.

Any thoughts on how to approach? I have downloaded text filter and smart filter by OKVIX but can't seem to figure out how to use them to accomplish this goal. 

Thank you in advance!

Mitch

[amitchandak]

@Shpongle , Not sure I got it. But see if this can help

https://exceleratorbi.com.au/text-filtering-power-bi/

[Shpongle]

Hi @amitchandak! Thanks for the reply - I did start my search for a solution with this article, but unfortunately I was not able to figure out a way to use it to exclude. The other thing is that it can only search for a single term, which is helpful but I need it to be able to search multiple terms otherwise it's not useful.

When I was geeking out with Access back in the day, I could create a text box on a form and the user could just populate it and use it to filter. I would just build my query to include/exclude the contents of the search box as needed.

Any other suggestions?

[v-chuncz-msft]

@Shpongle 

As far as I know, there is no elegant way. You may share feedback via Ideas to help improve Power BI.