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       desktop

Kate       PP           TV

 

 

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

 

 
Need Help

6 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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'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

      • Stachu's avatar
        Stachu
        Icon for Community Champion rankCommunity Champion
        6 years ago

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

    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-25ca-4ff8-9348-681df09aafc9&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

     

    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.