Slicer for 2 Seperate Tables

Hi all,

I'm trying to implement a slicer that would filter records from 2 tables, Tasks_Previous_Month, Incidents_Previous_Month

When i've attempted to implement this and put into practice, only one table appears to follow the command.

The fields columns highlighted contain the common values. Is there a way to make this work? Thanks, Rob.

parry2k
1 year ago
rpjheeney change the cross filter direction of relationship to single instead of both, and then test the results.
Anonymous
1 year ago
Hi rpjheeney ,

Thanks parry2k for the quick reply. I have some details to add:
Establish a one-to-many relationship between the Categories table and the Incidents_Previous_Month table.
Establish a one-to-many relationship between the Categories table and the Tasks_Previous_Month table.

Then, use the topic of the Categories table as a slicer to filter two tables at the same time.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.
Slicer for 2 Seperate Tables.pbix53 KB

parry2k
Super User
1 year ago
rpjheeney change the cross filter direction of relationship to single instead of both, and then test the results.
Anonymous
Not applicable
1 year ago
Hi rpjheeney ,

Thanks parry2k for the quick reply. I have some details to add:
Establish a one-to-many relationship between the Categories table and the Incidents_Previous_Month table.
Establish a one-to-many relationship between the Categories table and the Tasks_Previous_Month table.

Then, use the topic of the Categories table as a slicer to filter two tables at the same time.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.
Slicer for 2 Seperate Tables.pbix53 KB

Forum Discussion