Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Text Filter Visual

Hello,

 

I am using Text Filter, which works fine for a single field in a specific table. 

Is there a way to expand this to filter on multiple fields in multiple tables? 

e.g. I have the field Site (url)  in a table and Country in anothet table. I would like to enter e.g. Belgium as search and show the results of the table with site containing Belgium and at the same time have the table with country also filter on Belgium.

 

Is there any way to do this dynamically? 

Need Help

4 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous ;

    You can create a bidirectional relationship for the filter field of multiple tables, so that multiple tables can be filtered by a single field, as follows:
    Method1:

    The final output is shown below:

     

    Method2:

    Or You could create a measure  to filter other table.

    Measure = IF(ISFILTERED('Table'[Country]), IF(MAX('Method2'[Country ]) in ALLSELECTED('Table'[Country]),1,0),1)

    Then apply it into filters.

    The final output is shown below:

    Another similar filter-Smart filter is recommended: https://okviz.com/smart-filter/

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

       

      thanks, tha twas very informative and useful. 

      One of the problems is however that I cannot get it to work on another page in the report, TEXT Filter somehow does not carry over to other pages yet, but I wil lkeep working on that, I probably need to fine tune that. 

      Linking the search field to other tables is fine, but since we are working with WEB page paths, in several languages and codepages, and with several million items to search, that is not a practical solution at the moment. 

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous ;

     

    Only buit-in slicer and custom visual hierarchy slicer could set sync slicer in power bi for now.

    "text filter" is not support in power bi for now, so you may these two slicers.

    or you may submit your idea in Power BI Ideas to make it coming soon.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      H, 

      Thanks, I will look at that. 

      One thing I noticed is that Test filter sets a filter on the visualisation, but it does not appear on the filter pane. (see below)

      A measure like :

      SHOW = IF(ISFILTERED('SearchTerms'[SearchTerm]), "Filtered","not filtered")
      will show filtered, but only for that page, so Text Filter seems page bound, too bad, since it is easy to use and what our users want, a search function that does not require selecting 1 or more items as in a slicer.