Solved: Slicer for 2 Seperate Tables

rpjheeney · ‎02-04-2025

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 · ‎02-04-2025

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Anonymous · ‎02-05-2025

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.