Forum Discussion
Row level security and default slicer
Is there a way to dynamically set a default slicer value when row level security is being applied. something like setting the first value as default. I have some users who should only default to one country and i also have some users who belong to multiple countries. How can i set a default slicer value only for those with multiple countries to default to the first country on the slicer dropdown?
Hi Anonymous
There is no generic way to achieve it.But you can try the linked workaround of the SQLBI :
https://www.sqlbi.com/articles/customizing-default-values-for-each-user-in-power-bi-reports/
Or to use personal bookmarks :
https://powerbi.microsoft.com/en-us/blog/announcing-personal-bookmarks-in-the-power-bi-service/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Ritaf1983 Thank you!
Happy to help 🙂
Hi Anonymous
There is no generic way to achieve it.But you can try the linked workaround of the SQLBI :
https://www.sqlbi.com/articles/customizing-default-values-for-each-user-in-power-bi-reports/
Or to use personal bookmarks :
https://powerbi.microsoft.com/en-us/blog/announcing-personal-bookmarks-in-the-power-bi-service/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly