Filter multiple tables based on a common column

[data_newbie]

Hello!

I have multiple tables with a common column. That column contains the exact same text content and their respective matches for each row. I'm building multiple visuals with those separated tables and I wanted to filter those visuals based on that common column. 

I have tried to merge the tables into a centralized one containing all of the relevant information but Power Query takes ages and never finishes processing the merge. Is there another way I can accomplish this? Use this common column on a slicer and filter all of those visuals simultaneously?

[Anonymous]

Hi, @data_newbie 

Can you provide some sample data and the output you expect? Sensitive data can be removed in advance.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tutu_in_YYC]

You need to create a dimension (table that has the common column) and create relationships between that dimension with all the other tables. Then create a slicer from the column from the dimension.


 

[uzuntasgokberk]

Hello @data_newbie,

You can use a slicer that have common column with sync other pages. You don't have to filter all pages. There is an option is sync. View-->Sync Slicer Pane. Once you filter on page 1 that will be filter automatically other pages if it syncs check.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |