Forum Discussion
Default slicer selection based on User level security
- 3 years ago
I added 'Blank' in dropdown and this fixed my problem for a while. Thanks a lot for help.
Hi. No you can't do that. Slicer selection can't be preselected with different states by user. If you need delimited filters for group of users you can implement RLS to keep the report filtered but the whole dataset will be filtered and the users can't remove that filter.
Reports can persist users manipulations. So if you keep it clean and each users filter their data, each time they open the report they can check data with the filtered data, but the first time they must click the filters to persist them.
I hope that make sense
Thanks for the response. We already have RLS security implemeted in the report and is working as expected. The only challenge is - I have slicer A with values A1 and A2 and this is is single select slicer. So if user U1 logins and sees the report, he/she will see the data related to A1 and since A1 was selected while publishing, so there will nbe no challenge. But if user U2 logins who has access to A2, then he/she will see blank report(as A1 was selected while pubishing report) and manually change the slicer value to A2 to see the data in the report.
I hope this makes the probblem statement more clear.