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
Anonymous
Not applicable

Dynamically filter other tables in model

Hi Experts

 

Is it possible to do the following. I have taken column trend from my FACT table (table A) and added this as filter to my report. Everything is fine. Tables B, C, D and E have the same columns "trend" all tables can be linked together using a common column Co.ID. 

Hear goes how can I dynamically point my filter to the right table based on what filter I am using, so if I select manufacturing filter I want to use trend column from table B as my filter in my report as opposed to table A trend column. And

 

If I select country I want to use trend column from table C as my filter in my report. And so on..

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Please can you share a snap of first few rows of your tables to better understand your case.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Please can you share a snap of first few rows of your tables to better understand your case.

Anonymous
Not applicable

Thanks Raj managed to solve the issue it was a relationship issue.

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.