Filter by list of values

[Anonymous]

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

[havsgaard]

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]

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

Thanks, 

E

[AgTooOldForThis]

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

[v-lionel-msft]

Hi @Anonymous ,

Please use the slicer visual instead of the smart filter.

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]

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! 🙂