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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Filter by list of values

Hello!

 

I want to filter one of my fields using a list of values that i have in excel. I wont be able to purchase the smart filter pro from appsource neither my organization will allow me to use the discontinued Filter by list plugin from DEVScope. Does anyone know any other alternative apart from this?

 

Thanks!

 

Regards

Arpit

6 REPLIES 6
IfaZ_1
Helper I
Helper I

Hi, 

 

anyone has an answer for this? mine Filter by List by Devscope can't work anymore. Need to repurchase. Is there any other ways/methods? 

havsgaard
Frequent Visitor

I simply doesnt understand why this kind of basic functionality of pasting in a list and use it for filtering, is not part of the standard visuals in Bi

Anonymous
Not applicable

Hi, did you ever find a solution to this please? 

 

Thanks, 

E

I have also been trying to find a microsoft certified solution.  Any luck?

v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please use the slicer visual instead of the smart filter.

v-lionel-msft_0-1594342725773.png

v-lionel-msft_1-1594342760443.png

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Anonymous
Not applicable

Thanks for the reply Lionel. This helps when i have only 3 or values to enter. If i want to filter by 100 values, this method wont be feasible. Do we have any alternative? Thanks for the reply though! 🙂

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.