How do I turn of implicit filter in slicer?

[jmkvalsund]

Hi,

I have a table Employees_Managers showing salesemployees and salesmanagers like this:

Employee	Manager
sales1@org.com	Manager1@org.com
sales2@org.com	Manager1@org.com
sales3@org.com	Manager1@org.com
sales1@org.com	Manager2@org.com

etc..

The idea is to create a chart showing the result of the selected salesperson, from the ones each manager has access to. And each salesperson may be available for several managers.

When I put the Employee column in a slicer and Manager1 is logged on, it shows only the Employees which is exclusive for Manager1, in the above example only sales2 and sales3. If I remove the last line, it also shows sales1.  

I determine the logged on manager like this:

M_CurrentManager = USERPRINCIPALNAME()

M_IsCurrentManager = IF(SELECTEDVALUE(Employees_Managers[Manager])=[M_CurrentManager],1,0)

Then I put a filter on the slicer like this:

When I remove this filter, I expected to find sales1@org.com listed twice in the slicer. But it seems like the slicer has an implicit filter? I suspect thats what makes trouble, is there a way to disable this?

Regards,

John Martin

[vicky_]

Slicers will not show any duplicate values. If there's another slicer impacting that, you can check that by clicking on the filters button and disable the visual interactions between those slicers.

[jmkvalsund]

Yes, I've checked that out, and the only filter applied is the one mentioned above, "M_IsCurrentManager is 1" and that is as expected. I've also put M_IsCurrentManager on a card to monitor its value.

Assume logged on manager is Manager1.
When I remove  filter "M_IsCurrentManager is 1" from my slicer, then sales1 shows up in the slicer. But if I then  select "sales1" from the slicer, the value of M_IsCurrentManager = 0...  Which tells me the slicer shows sales1 from the last line of the table, where manager is Manager2. And thereby M_IsCurrentManager = 0.

Why does the slicer select this line, instead of having an implicit OR-function which returns both lines containing sales1, and then then let filter on M_IsCurrentManager decide which option to show? 

Is there another to achieve this? As mentioned I would like to give several managers access to some of the same sales-persons.

Regards,
John Martin