You might be able to craft something like that with a sheet selector - Sheet Selection on Steroids | VizPainter - but why not just provide two different views? One for your Exec folks and another to the rest of the group?
I appreciate the time, We ended up just doing two different views. There wasn't a 100% clean solution.
Again, thank you!
I have some dashboards that certain users aren't allowed to view.
I have users placed into Groups (set on Server). Power users can see the dashboard (and only power users get the buttons that have the actions to navigate to the dashboard, but nothing stops the general users from clicking the tab at the top to go to the dashboard.) General users should not see it.
When a general user goes to that dashboard, I have a pop-out that covers the whole dashboard. It is a sheet that simply says, "you are not authorized to view this dashboard. Click here to return to the main dashboard." And at that point all they can do is click it. And that sheet has an action to go to the main dashboard.
If you are using ISUSERNAME() to control the users, you can do the same thing. I just use ISMEMBEROF(), which looks at the group level. (And if you have multiple users who can see that dashboard, it's a whole lot easier to manage them at the group level, in my opinion. Further, and people come and go, you just manage it on the server, and no usernames are hardcoded in the calcs that control this.