Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I am seeking help for PBI Report Builder - which forum is best to post questions?
Within the dataset filter - I am wanting to use a NOT contains filter. I have attempted the custom expression option, but to no avail.
I would appreciate advice on converting this to a "NOT Contains"
Go to Solution.
Hi @Dellis81 ,
If I understand correctly, it seems that you want to filter the data which not contains some specific values. Am I right? If yes, you can refer the following links to get it:
Working with Reporting Services Filters – Part 4: Creating a NOT IN Filter – Data Inspirations
sql - How to implement 'Not In' Filter in SSRS? - Stack Overflow
SSRS : Simulating NOT IN and NOT LIKE Functionality In SSRS Filter Expressions - TechNet Articles
In addition, you can apply the codes in the data source query as below:
WHERE Production.ProductInventory.ProductID NOT IN (@ProductID)
View solution in original post
Thank you for your response and thoughts. I will see if I can make one of your suggested links work. I had previously searched, but seems the 1st option is a little more clear than what I had experienced before.
Will get back in touch - probably this weekend.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.