User access


I have a scenario where the user has to see his own details only in few Dashboards and in 1 DB he should see his associate details,

If I restrict the associate to the user in the users the first option is working fine however the last DashBoard he is unable to see his associates.

If we provide all associates in Associate access then last Dashboard is working fine but he is able to see all his reportees in other 3 DB as well.

How can I fix this issue