Forum Discussion
Filter dataset based on multiple inputs(Strings).
Hey! I've found the solution i needed for this problem after 2h+ of googling and tweaking.
Video: Power Bi - Filter by Multiple Comma Separated Values - YouTube
It is a visual called Mass filter that does exactly what i needed.
Need help installing/using it? Check out the amazing video as seen above.
Hi Anonymous , I hope this solution will help you.
I have tried the Smart Filter Pro and I don't think it supports copy pasting multiple values.
You will have to type in multiple values and select one at a time.
This is also available in the default slicer visual, where you can type in one value at a time and do the selection.
You will need to turn off the 'Single Selection' and turn on the 'Multi-Selection with Ctrl' from the formatting pane of the visual.
However, if this does not work for you and if you want a substitute to the Smart Filter Pro, then you can have a look at the 'Attribute Slicer' custom visual.
It is made by Microsoft itself, so I doubt there should be any problems in getting it approved from the admin.
Here is a video for the attribute slicer:
https://www.youtube.com/watch?v=hamLu0tYSRo
Please let us know if this works for you and if not, kindly share your solution once you resolve the problem.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Indeed the selecting multiple values was found by me aswell. I will have a look at the smart filter pro however it is a must to copy paste all values. Since like i said i could be working with 100s of filter values. I can't type them all if i did that im better off using the normal Slicer already equipped in Power BI since u can then select all values aswell. I will take a look at smart filter pro. Thanks in advance!
Anonymous ,
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
The Smart Filter Pro Copy & Paste is exactly what i was looking for... However this is a paid subscription and as such i won't be able to use it. However i can use it as an example for people to understand what i need. So thanks anyways! I used the demo and it worked how i'd need to use it.
Hi Anonymous ,
As the solution is working for you.
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!Hey sadly the solution does not work since it is a paid subscription based visual. However i have found the solution and will comment about this and accept it.