Forum Discussion
Text slicer: pasting multiple values
Hi arawo ,
Thank you for the confirmation.
It's not currently possible to paste a comma separated list like blue, red, black directly into a native text slicer and have it filter by partial matches. However, this use case is well supported through other options.
The most effective approach is to use the free "Filter by List" custom visual from AppSource, which allows you to paste multiple values into a textbox and filters your data accordingly, even with partial matches in descriptions.
Alternatively, Power BI new list slicer( Preview features) supports pasting a list of exact values to filter, though it only works with full match.
While a DAX-based workaround using a disconnected input table can simulate this behavior, it is more complex and static. For ease of use and flexibility, the "Filter by List" custom visual is the recommended solution.
Hope this helps.If so,give us kudos and consider accepting it as solution.
Regards,
Pallavi G.
Hi arawo
Sorry for the slow reply!
Just enable Slicer Setting ->"Accept multiple values" in your text slicer settings. Then:
Type your first value and hit Enter,
Add the second value and press Enter again.
That’s it—you’re all set!
Here’s a quick video to show you how: https://www.youtube.com/watch?v=LbnY7uoU6bA.
I am aware of this solution, but as I mentioned in the first post, this solution takes a lot of time when I have to add many values, that's why I was looking for a solution using DAX.
Hi arawo ,
Thank you for the confirmation.
It's not currently possible to paste a comma separated list like blue, red, black directly into a native text slicer and have it filter by partial matches. However, this use case is well supported through other options.
The most effective approach is to use the free "Filter by List" custom visual from AppSource, which allows you to paste multiple values into a textbox and filters your data accordingly, even with partial matches in descriptions.
Alternatively, Power BI new list slicer( Preview features) supports pasting a list of exact values to filter, though it only works with full match.
While a DAX-based workaround using a disconnected input table can simulate this behavior, it is more complex and static. For ease of use and flexibility, the "Filter by List" custom visual is the recommended solution.
Hope this helps.If so,give us kudos and consider accepting it as solution.
Regards,
Pallavi G.Hi arawo ,
I hope the suggested solution worked for you. If your issue is resolved, kindly accept the post as a solution — it helps the community identify helpful answers more easily.
Thank you.