Here is a dashboard I built (sorry for all the blurring but I didn't want to risk getting in trouble). On the top-right, encircled in red, is a parameter with the name of every ASM (Area Sales Manager) in my company.
The directors want each ASM to be able to view the information for everyone in their department. For example:
John needs to be able to select John, Janice, Jacob, and Jerry on the ASM parameter, but should not be able to select Blake, Boris, Betty, or Bob. Blake can select Blake, Boris, Betty, or Bob, but not select John, Janice, Jacob, or Jerry.
Is there a way I can do this with a parameter? It has to be a parameter my data comes from multiple data sources. Sorry I can't attach a workbook, it's highly sensitive, plus it's all permission-based so I don't think it will help anyway.
Hello Ailsa - To answer your question in one word, Parameters can't be made dynamic.
But there is a crude solution to it as well (sorry, I couldn't find any better sol): In that case you probably need to publish 4 different version of Dashboard with 4 param.