Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kerk_03
Frequent Visitor

Using Text Filter to filter multiple tables on 1 page

kerk_03_0-1679004597294.png

kerk_03_3-1679005152655.png

 

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.

kerk_03_1-1679004713732.png

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

kerk_03_2-1679005098711.png

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

2 REPLIES 2
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors