Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello
I am seeking help for PBI Report Builder - which forum is best to post questions?
thank you
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"
thank you!
Solved! 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
=Iif(InStr(Join(Parameters!FilterList.Value,”,”),Fields!Category.Value)=0,True,False)
sql - How to implement 'Not In' Filter in SSRS? - Stack Overflow
=IIF(Array.IndexOf(split("30,31,32,33,34,35,36,37,38,39",","),
CStr(Fields!YourField.Value))>-1,"Exclude","Include")
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)
Best Regards
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
=Iif(InStr(Join(Parameters!FilterList.Value,”,”),Fields!Category.Value)=0,True,False)
sql - How to implement 'Not In' Filter in SSRS? - Stack Overflow
=IIF(Array.IndexOf(split("30,31,32,33,34,35,36,37,38,39",","),
CStr(Fields!YourField.Value))>-1,"Exclude","Include")
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)
Best Regards
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.
thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
129 | |
78 | |
76 | |
60 | |
53 |
User | Count |
---|---|
164 | |
86 | |
68 | |
68 | |
58 |