How can I use a text filter all over my table?

[Yonas]

I like to filter my table using text filter, not on one column but on multiple columns. my data looks like this

Name    Service     product

Jhon      Word       laptop

Jim         Excel       desktop

Kate       PP           TV

How can I use text visual filter to work all over the columns? Any thoughts?

[v-juanli-msft · Accepted solution]

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/

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=37766cd6-...

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.

[Stachu]

can 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?

[Yonas]

Ok, 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

[v-juanli-msft]

Hi @Yonas 

I follow the guides of this link  and create what is similar with your expected output.

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.

[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.

[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