cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217 Member
Member

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

Accepted Solutions
Raja26 Frequent Visitor
Frequent Visitor

Re: Dynamically filter other tables in model

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
Raja26 Frequent Visitor
Frequent Visitor

Re: Dynamically filter other tables in model

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

View solution in original post

Route217 Member
Member

Re: Dynamically filter other tables in model

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,173)