Forum Discussion
Microsoft EmployeeHow can I use a text filter all over my table?
Hi Yonas
There is no built-in slicer currently to realize this feature.
Please share some detailed case or desired result so we can work out a workaround.
Here are some examples and workarounds to these.
https://www.sqlbi.com/articles/creating-a-slicer-that-filters-multiple-columns-in-power-bi/
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Championcan you give an example on how you would filter the table you posted? I'm not clear what you mean by filtering multiple columns
by default crossfiltereing is active e.g. if you filter 'desktop' in the [product] column, that means [Name] is crossfiltered to 'Jim' and [Service] is crossfiltered to 'Excel'. So it sort of works for all columns by default, but I assume that's not what you're looking for, correct?
Microsoft EmployeeOk, here is some details. my table looks like this
Name Service product
Jhon Word laptop
Jim Excel desktop
Kate PP TV
And i have a text filter(search) in my report, when i type "Jhon", i want to see the first row, if i type "PP", I want to see the third row and if i type "desktop" i want to see the second row, something like that. I want the search filter to work on all columns.
Thanks
- Stachu
I assume you are using custom visual, correct? I think the first of v-juanli-msft is the way to go, basically combining the columns into one and applying filter to that
v-juanli-msftCommunity Support
- Yonas
Thank you all for the suggestions. I actually fixed it by concatenating the columns into a new column and call that calculated column in my text filter.