How to restricting Dashboard parameter values based on User filters
Restricting Dashboard Parameter Values Based on User Filters
In some cases, you may want to restrict the values displayed in a dashboard parameter based on the user accessing the dashboard. Although you cannot directly apply user-based filters to dashboard parameters, you can achieve this by applying user-based filters to the data source column used in the dashboard parameter. This will indirectly restrict the values shown in the dashboard parameter based on the user.
Steps to Restrict Dashboard Parameter Values
- Create a dashboard parameter based on the desired data source column (e.g., CustomerID).
- Apply a user-based filter for the same data source column used in the dashboard parameter (e.g., CustomerID).
Note: The data will be displayed for the user based on their selected filter. If a different user wishes to filter the data, they will need to customize the filter value according to their needs.
- The dashboard parameter will now be restricted based on the user-based filter information in view mode.
By following these steps, you can ensure that the values displayed in the dashboard parameter are limited based on the user accessing the dashboard, providing a more personalized and secure experience.
Related Links
