I'm working on a project that displays student dashboards at the moment. I want to include a slicer in the dashboard, but I don't want the students to be able to see it. Only the tutor, who has entered his or her password in the text search slicer, will be able to see the slicer with the names of their students in it. I have an excel file containing each student's name, role (tutor/student), and password for that purpose. Neither do I want RLS to be performed nor do I want the password to be hardcoded inside the measure. I want DAX metrics to be used for this. Additionally, there will be various student names for different tutors because I am doing this for multiple classes. I want the tutors to be limited to knowing the names of their students and nothing else.
