"FILTER BY LIST" IS NOT

[baBI123]

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): 
789d
909b

[v-chuncz-msft]

@baBI123,

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.

[baBI123]

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