Report builder not like or does not contain parameters/filters

[Vytalion]

Hi, I am pretty new to power bi report builder. I have to create a paginated report of a power bi desktop report. ( Well only some of the graphics and stuff.) I have been figuring out a bunch of stuff but one thing i cant figure out is how to do "does not contain" or "not like". I have tried many things, even found a nice tutorial on youtube showing how to use the like filter as a wildard and what not. But i found nothing about not like or does not contain. I really really need help... Report builder is starting to give me anxiety induced heart pain because i cant find the answer. Any help is appreciated. thanks

[JonesJonesJones]

I was searching for this today and couldn't find the correct answer. The proper way to do this is to do the following.

Expression: =InStr(Fields!Field Name.Value, "text to exclude")
Operator: =
Value: =0
You need to input the expression and value as an expression (the fx button).

[rubayatyasmin]

Hi, @Vytalion 

Unfortunately, Power BI Report Builder doesn't have a direct "Not Like" or "Does Not Contain" filter operation in the UI, but there is a workaround using expressions. You can write an expression in your report to filter the data as needed.

Here is how you might do this:

1. Right-click on the dataset you want to apply the filter to and click on Dataset Properties.
2. Navigate to the Filters page.
3. Click on the Add button to add a new filter.
4. In the Expression field, write your expression. This will be the field you want to filter on. For example: =Fields!YourFieldName.Value
5. In the Operator dropdown, select the 'Like' operator.
6. In the Value field, write your expression using the NOT operator. For example, to filter out all values containing "abc", you might write: <>"*abc*"

Remember, the "*" is a wildcard character that matches any sequence of characters.

This will apply a filter to the report which excludes any values containing "abc". You can adjust this as necessary for your specific needs.

[Vytalion]

Hi,

Thanks for the quick reply, i appreciate it. I completely forgot to try <> to be honest but it sadly didnt work. Im not sure why, there is no error or anything like that, it shows the report witht the table/titles/image i put but no data as if it removes every name of the AccountManager list that im trying to filter. I tried creating a new table to make to double check bust same thing happens...