Forum Discussion
Filter Multiple Sheets with Common Column
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 👍
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 🤗