Forum Discussion
Page Navigation Challenge
Hello Community, I've watched several videos on this and read various blogs but none of them seem to quite do exactly what I am looking to do. I have a report with 4 pages, all hidden exc...
Anonymous
You should be able to calculate it just using the logged-in user's USERPRINCIPALNAME() which would not require a selection.
Navigation = VAR _UPN = USERPRINCIPALNAME () VAR _Role = CALCULATE ( SELECTEDVALUE ( 'Page Level Security'[Role] ), 'Page Level Security'[UserPrincipalName] = _UPN ) RETURN IF ( _Role = "Manager", "Executive Summary", "Limited Access" )Then combine that with conditional page navigation for buttons.
https://www.youtube.com/watch?v=M1TZ5NCQKXo&ab_channel=HavensConsulting
Anonymous
You should be able to calculate it just using the logged-in user's USERPRINCIPALNAME() which would not require a selection.
Navigation =
VAR _UPN =
USERPRINCIPALNAME ()
VAR _Role =
CALCULATE (
SELECTEDVALUE ( 'Page Level Security'[Role] ),
'Page Level Security'[UserPrincipalName] = _UPN
)
RETURN
IF ( _Role = "Manager", "Executive Summary", "Limited Access" )
Then combine that with conditional page navigation for buttons.
https://www.youtube.com/watch?v=M1TZ5NCQKXo&ab_channel=HavensConsulting
Brilliant jdbuchanan71 Just tested and it looks like this is going to work! Thank you Thank You!