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 Si...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community 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.