Forum Discussion

rpjheeney's avatar
rpjheeney
Frequent Visitor
1 year ago
Solved

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, o...
Need Help
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    1 year ago

    rpjheeney change the cross filter direction of relationship to single instead of both, and then test the results.

  • Anonymous's avatar
    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. 

Anonymous's avatar
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.