Forum Discussion

stokidez's avatar
stokidez
Icon for Helper III rankHelper III
5 years ago

Lock Slicers for Different Users

Hi folks,   I have a single page dashboard which can be filtered by department. I would like, once published, to push this out to different users across an organisation, who work in different depar...
Need Help
stokidez's avatar
stokidez
Icon for Helper III rankHelper III
5 years ago

Thanks for the response vanessafvg .  More so from a user experience point of view, row level security sounds too extreme for this case. I purely want to set the slicers to certain value depending on the audience - is what I'm asking for possible?

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

I think its be possible;

 

First off you would need a list of users and what department they map to.  Using the  the userprincipal () function to bring back that user name and then map it to which department.

 

Then you could probably create a switch statement with a dynamic slicer to return the value dependent on department.

 

userprincipal

https://dax.guide/userprincipalname/

https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/dax-query-language-for-power-bi-and-power-pivot/userprincipalname-show-user-name-and-use-it-in-rls-dax-power-pivot-power-bi/

 

switch()

https://docs.microsoft.com/en-us/dax/switch-function-dax

https://towardsdatascience.com/using-slicers-for-dynamic-chart-adjustment-in-powerbi-47d0ea1b839e