Filtering on the base of Employee ID only

[Anonymous]

Hi Team,

I have a requirement of filtering below table only on the base of Employee ID

Emp Id	Start Time	End Time	Hours
612896	12/4/2017  5:33:00 PM`	12/5/2017 15:52	12
612896	12/6/2017  4:23:00 PM`	12/7/2017 13:52	10

When I click on Emp Id row , the value I get in other table should be all rows for 612896, but it gets filtered for all column values and not only Emp Id.

I am getting below 

Emp Id	Production Date	Hours
612896	12/5/2017	12

while I am expecting the result as :

Emp Id	Production Date	Hours
612896	12/5/2017	12
612896	12/6/2017	10

How to make sure the filter is applied only on Emp ID and NOT all columns?

Thanks

Swapnil

[v-chuncz-msft]

@Anonymous,

Add an employee Table which contains all the unique [Employee ID], create relationship on this column and drag it to table visual.

[Anonymous]

Yes I have created employee master and using employee ID from this table , still it filters for a whole row(i.e. all column values in that row). While I just wanted to filter only on Employee ID.

[v-chuncz-msft]

@Anonymous,

Check the relationship between tables.

[Phil_Seamark]

Hi @Anonymous

One option is to use a slicer that only uses the Employee as it's value. 

[Anonymous]

How can more than 1 column be selected in slicer... as I wanted to dipslay in tabular format.