Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello
I have a table with many columns ,the user needs to lookup for many values (not with slicer only with entering the value)in the same time and get the summarized result
is it possible with Power Bi?
Solved! Go to Solution.
@Anonymous
Thanks for your help, i need a slicer in the report not the filter options in the report there is a slicer but it's not free use
Hi @Enzo_849 ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
Hi @Enzo_849 ,
if my understanding is correct, you can use this visual to enter manual filter strings:
Text Filter (microsoft.com)
... and make sure to leave a comment in the ratings-section asking to stop the planned deprecation of this visual.
To my knowledge, there is currently no free alternative.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Thank you for your help but with this visual i can lookup for only one word ,in my case i need to filter for many words at the same time
Oh, I see.
Then you have to open your pockets and go with the pro-version here: Introducing Smart Filter Pro - OKVIZ
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @Enzo_849 ,
Does this input filter meet your requirements?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!