Forum Discussion
Override Row Level Security
Here are some pictures to help, hopefully. Let's say this is my table of information:
So far, I've been able to make the Row Level security to be dynamic with the IF functions used above. So if Gabriel Stokes, a sales person, opens the report he would see this:
If Maggie Green, a sales manager opens the report, he would see this:
If Daryl Dixon, a vice president, opens the report, he see's this:
Where I'm having trouble is that I'd like to find a way that the user can shut off or do something to be able to see all the data. I've tried puting conditional clauses using slicers in the RLS function, but it doesn't seem to work. I don't know if there's a method to do this. Is there coding I could put in the RLS function above to give the user power to change which column to filter for RLS? I want the user from sales people to vice presidents to be able to do something, like click a slicer or anything so they could see all the data like this: