Slicer Drop Down - How To display "All" or Role specific

[bcap01]

Hello, Is there a way to make a slicer drop down show "All" and an option based on Role?  

For example, "All" would represent stats and analytics for the entire company.  Otherwise, I would only be able to see stats and analytics for the specific Role I belong to (For example: "IT").

[v-rzhou-msft · Accepted solution]

Hi @bcap01 ,

Here I suggest you to try RLS in your report. As far as I know, "ALL" selection will always appear if you turn on select all function.

My Sample:

You can create roles for Company Manager to show all values and other roles to show by their role.

Result is as below.

View as Manager:

View Other users:

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.