Skip to main content

Power BI

New

Slicer to search multiple values in a field separated by a comma

Vote (9) Share
's profile image

on 03 Oct 2017 00:51:11

I would like a slicer where I can enter multiple values to search in a certain field, and the values would be separated by a comma (like SSRS reports have).

So, I could search cat, dog, fish in column A, and all instances that those three terms were used would come up.

Comments (3)
's profile image Profile Picture

cec9cd8d 092b-43c0-ac51-902bbcb4a583 on 06 Jul 2020 00:13:19

RE: Slicer to search multiple values in a field separated by a comma

This custom slicer has the functionality we need BUT...
Currently no support for bookmarking the entered values in that custom visual.
Currently no support for synchronization across pages.
Poorly visually designed slicer.

Filter by List by Devscope

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381413?tab=Overview

having this functionality in a native power BI slicer would be awesome. Many times we have a howe list of article codes, customer codes, whatever,... out of another IT system we quickly want to see the values from in the power BI report.

's profile image Profile Picture

181d0a7e e82a-49b4-8b95-bd704408da59 on 05 Jul 2020 23:42:02

RE: Slicer to search multiple values in a field separated by a comma

My company is migrating from Spotfire to Power BI and this is very easy to do in Spotfire. We frequently have to filter tables of 10,000+ values down to 100 desired rows, and use Excel to produce a delimited string which is pasted into the filter. Current slicers only offer one-by-one ticking of boxes to achieve this which isn't practical.

The same should also be applied to filters.

's profile image Profile Picture

1e3e0a9f 3df8-4e45-94d2-0f5a5a3cd0f9 on 05 Jul 2020 23:17:50

RE: Slicer to search multiple values in a field separated by a comma

Or do it with any syntax at all........just tell us what it is.