Using Text Filter to filter multiple tables on 1 page

[kerk_03]

Example: I have 2 tables where I need to filter both at the same time.  I have added in the Text filter to just type in and filter both, however you have to put in a field that selects 1 table. This only filters 1 of the tables and the results are blank for the other.

I thought it was a relationship issue as I don't fully understand it except that the same name columns = are related.  I have tried every different type of combination to get this to work with the same result.

I have found that people post information about Slicing, but in my case, the wording matters and the slicer wouldn't work as partial search is needed.

Utilizing Text Filter

to be able to filter multiple tables on the same page.

[amitchandak]

@kerk_03 , better to have a common dimension. and then use a text filter on common dimension

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

[kerk_03]

Thank you, but i feel like that is a long complex way to do something so simple.  Maybe PowerBi isn't as great of a tool as i thought it to be.  I found this a little bit ago and it has me perplexed as to hes having the exact opposite effect as I am and I want to be able to do what he has done.  I guess the Tables must match exactly.

https://community.powerbi.com/t5/Desktop/Text-Filtering-applied-to-only-one-visual/m-p/2508664