Forum Discussion

Yonas's avatar
Yonas
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

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

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       d...
Need Help
Yonas's avatar
Yonas
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    Yonas
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    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.