Power BI Desktop Slicer not showing all Names

[subhadip]

Slicer has been used  to Filter Data by Employee Name , altough in the Model  traversing is happening through Empid . Since Employee Name is aware by Business , so Employee Name has been used.

Even though we have Employee Name as duplicate it is not showing up in the sclier (It  should show 2 names even though they are same ) . While printing the data in the table we can see duplicate name is getting printed with different EmpId but Sclier shows 1. Please suggest

[v-yuta-msft]

Hi subhadip,

When you create a slicer visual based on one column, it means same value in the column will be a category though values in other columns in that row may be different. 

In addtion, do you want to filter other columns using [Employee Name] column and [Empid] column? If so, you can create another slicer based on [Empid] column.

Regards,

Jimmy Tao

[subhadip]

User is searching Employee Data based on name .

Is it the property of the  Sclier to show always DISTINCT value .   Our expectation is  even though  employee name are duplicate 

it should  come up in the slicer .

Kindly suggest 

[Stachu · Accepted solution]

Slicer will always group together the same string, filtering both employee ids.
I'd suggest concatenating the Employee Name with Id in order to have unique values