cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baBI123
Helper II
Helper II

"FILTER BY LIST" IS NOT

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

Untitled.png

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@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.

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

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.