(New) Text slicer Excel/column dump

[Anonymous]

Hello all, 

The new text slicer is an awesome way to search for values and selecting all without selecting all outcomes individualy. However, one big purpose is as far as my understanding goes not possisble. This would be to copy a column (or other values) from e.g. Excel and pasting it in the slicer to select all those cells seperately. Is this possible by any chance?

Kind regards!

[rohit1991 · Accepted solution]

Hi @Anonymous 

At the moment, the new text slicer in Power BI does not support pasting in a list of values (like a whole Excel column) to bulk-select items. Each item still needs to be selected manually or through search.

Could you please try below steps:

• If you often need to filter by a long list of values, load that list into your data model (as a separate table) and use it as a slicer or relationship filter.
• Alternatively, you can create a parameter table or use DAX measures with TREATAS() to filter your main table against an imported list.
• Some users also pass a list of values via Power Query parameters or through dynamic filtering in the service (using URLs with filter parameters).

So, natively it’s not possible to paste a column into the text slicer, but modelling or parameter workarounds can achieve the same outcome.