Display slice if [Sector] = "Group1" and if USERNAME()=[Email] and Access Level = Lead

Display slice that matches all [Sector] and if USERNAME()=[Email] and Access Level = Lead

So Im trying to give access to all "Lead" role that they can see all details based on sector 

agent_p_0-1675480206443.png

 

0 2 115
2 REPLIES 2

1. Create slice for that table and name it as 'Current User'. The filter condition would be [Email] = USEREMAIL()
2. Go to your desired view and put this expression in the Show_If

AND(
	INDEX(Current User[Sector], 1) = "Group 1",
	INDEX(Current User[AccessLevel], 1) = "Lead"
)

 

Can I set a username filter condition?

Top Labels in this Space