Forum Discussion
Filter Multiple Sheets with Common Column
Hi there,
I have (hopefully!) a straightforward query but forgive me, I'm still quite new to PowerBI.
I have built a report using 4 separate sheets (i.e. due, outstanding, current, completed) and they all have common columns 'Department' and 'Line Manager'.
I want to be able to filter all data from the 4 sheets by Department and then by Line Manager. Slicers only allow me to select one column from each sheet (which means it doesn't filter all my visuals and all 4 sets of data) before I get conflicting relationships. I've tried setting up relationships between the sheets and the 'Department' column which is fine, but once I try to set up another for the line manager, it conflicts.
I've also tried applying filters to the entire page and report but again, it only allows me to select one column from one sheet which means it only applies it to one sheet and not the 4 sheets.
Is there an easy way to apply a filter to a common column on multiple sheets of data?
Thanks in advance,
Claire
Hello,
You should have a seperate table with all your departments and create a relationship between it and the 4 other tables. In this way you can get the department name from the=is new table and use it in a slicer and it will filter all the 4 tables.
You can check this article that would help you understand it more https://radacad.com/basics-of-modeling-in-power-bi-what-is-a-dimension-table-and-why-say-no-to-a-single-big-table
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
2 Replies
Hello,
You should have a seperate table with all your departments and create a relationship between it and the 4 other tables. In this way you can get the department name from the=is new table and use it in a slicer and it will filter all the 4 tables.
You can check this article that would help you understand it more https://radacad.com/basics-of-modeling-in-power-bi-what-is-a-dimension-table-and-why-say-no-to-a-single-big-table
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila thank you so much for this. I've done one sheet for Department, then one for the line manager, and created the 4 relationships between Department and the 4 sheets, along with one relationship between Department and the separate line manager sheet 🤗
