Date and code slicer for two data sources having alot of duplicates Values

[kareemSultan]

Dear all , 

I have 2 data sources having date and idcode column in both and the two are related each other 

so i want to create relation between both sources to support my dashboard slicer to filter by date and interview code 

i created relation between the two datasets by code and src (src== code) and its work great but once i apply the date slicer , it doesnt work and only filter one source only ,, the relation between the interview code and src is many to many as each interview code have numbers of calls per day and each interviewer code have many record in daily progress as each day they do successful surveys 

i want to make relationship between interviewer code and src and call date and date 
to make slicers on date and co

[v-yilong-msft]

Hi @kareemSultan ,

It seems that you are trying to create a relationship between two data sources in Power BI to enable filtering by both date and interviewer code.

From both data sources, extract the unique dates and interviewer codes. Combine these into a new table, ensuring each combination of date and code is unique.

Establish a relationship between your original data sources and the new bridge table. Connect the ‘Date’ columns of your data sources to the ‘Date’ column of the bridge table. Connect the ‘Interviewer Code’ and ‘Src’ columns to the corresponding ‘Code’ column in the bridge table.

Finally you can use the bridge table to configure your slicer.  This will allow you to filter both original data sources simultaneously.

Best Regards

Yilong Zhou

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