Slicer for 2 tables

[RafaelAri]

Hello to all the experts,

I have 3 tables:

1. Customers Sales
2. Customers Billings
3. Calendar table

A specific customer may appear in either Sales, Billings, or both.

The Calendar table is linked to both tables, so when I use a Year slicer, it filters everything based on the selected Year.

However, I'm facing an issue when trying to link the Customer-Name field in both tables. It is not functioning as expected.

Could you please advise on how I can create a Customers slicer that will impact both tables simultaneously?

[Dhairya · Accepted solution]

Acccording to my understanding to your question, you want to use customer name as slicer and it should update all visuals on selected value.

To achieve this you have to first configuring relationship between you tables.
the row of the table you want to use as slicer should be in one-to-many cardinality to filter data accurately.
If the issue still persists you can create seperate dimension table having unique values which you will use as slicer.

Please mark my solution as accepted if it works.