Text Filter- Need no items shown if blank and only allow exact text to result in showing a item.

[mwackers]

I am building a Power BI report to allow people to enter a Unique Case ID and only return the information for that case.

The Unique Case ID in contained in the Title field.

I want the text search bar to only return a single case if it matches the Unique Case ID exactly.

Here is my filter to see if a search has been performed.

If no search, the search bar is blank it returns a zero., But the filter is not working and shows all the cases.

If there is part of a Unique Case ID it should, show a case, like the example below

and it should not show multiple results.

Only the following should return a result. A complete Unique Case ID that is an exact match.

Any help would be appreciated.

[Anonymous · Accepted solution]

Hi, @mwackers 

May I ask if this is the expected output you are looking for? Based on your description, I have found a visual named Text Filter that accomplishes what you are looking for, note that this visual only supports filtering on a single column of values. Following picture shows the effect of the display.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Dangar332]

hi, @mwackers 

try to use has HASONEFILTER() it check column is filterd and only one item selected or filterd

filter check =
hasonefilter(tablename[columnname])

[mwackers]

No luck yet. Here is what I did.

[Dangar332]

hi, @mwackers 

you didn't select any case id thats why it retun false if you select only and only one id then it retun true . it's boolean expresion

[mwackers]

How can the results show no rows if it is false?