Slicer for 2 coloumns

[azizalfarhan]

hello,

Im working on a report to show attendance i have 3 data imports.

table 1) has employee data

table 2) has employee id + arrival time

table 3) has employee id + leaving time

i would like to have a slicer to display a week report for employees attendance. currently my issue is that the slicer only affects one table.

  thank you,

[v-xiaoyan-msft]

Hi@azizalfarhan,

Please check the relationship settings between the three tables. Ensure that filtering by ID can be done properly.

If this does not work, please provide some details.

Hope it helps.

Best Regards,
Caitlyn Yan

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

[amitchandak]

@azizalfarhan ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[azizalfarhan]

unfourtantley i cannot share the PBIX as its consist of sensitive DATA.but basicely the data as follow. this is a rough data sketch. basically it records when user enter and leave