Forum Discussion
(New) Text slicer Excel/column dump
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.
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.