I am new to Power BI, I am struggling to implement RLS for last few weeks. I am not sure how to proceed with my scenario, please someone help me to give me idea to implement my scenario. its great help.
here is my requirement.
My tables are:
Report 1 and 2 will change based on the user login and permission level ('User Access' and 'User Permission'.). if am team head then i can see all team progress in summary view and if i am login with branch head then i can see all department and team progress.
Two level of reports
Report 1: summary of all one's from completed, in progress and issues. User click on the number then the
Report 2 will display with those related values based on the 'User Access' and 'User Permission'.