Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II


Hello everyone, 

I am loving the new "Filter By list" BUT I want to be able to put a list of 1000 PN's and for all the PN's that are NOT in the original list of 1000 PN's to show up. Kind of like a "IS NOT" function.... Does that make sense? If not, let me know so I can reword my question. 

Here is an example of what I want: 

In my Oracle database I have PN's: 123c, 567a, 345b, 
In my "BULK SEARCH BOX" I put a list of the following PN's: 123c, 567a, 789d, 909b


and then I want there to be a visual that lists the value(s): 


Community Support
Community Support



As far as I know, the list needs to be entered into a table. Then you may add a measure and take advantage of Visual level filters.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I am no master at POWER BI. I am still learning a lot. Can you walk me through a step by step process on how to accomplish this? @v-chuncz-msft

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.