Forum Discussion

Nehawns's avatar
Nehawns
New Member
3 years ago
Solved

Default slicer selection based on User level security

We have a dashboard where we have implemented row level security and the defauls slicers selection is based on the different user roles. The dashboard should automatically change the slicers based o...
Data Protection
Need Help
  • Nehawns's avatar
    Nehawns
    3 years ago

    I added 'Blank' in dropdown and this fixed my problem for a while. Thanks a lot for help.

Nehawns's avatar
Nehawns
New Member
3 years ago

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.

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
3 years ago

Well. Unless you have a requirement for specific visual to be filtered, then it's a good practice to keep your slicers unselected before saving and publishing. That way the User2 won't see the filter A1 at all. 

Sadly slicers can't change with the logged user. There is no way to do that. Only RLS can filter data by logged user.

I hope that helps,