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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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