Value of the Parameter Based on the Logged-In User in Bold BI
In Bold BI, it may seem challenging to use the dashboard parameter in a user-based filter to restrict the parameter value. However, there is a workaround to this limitation. This article will guide you on how to restrict the value while using the data source type dashboard parameter.
Steps to Restrict User Interaction
-
Create a New Data Source: The first step is to create a new data source. This will be used to add the Data Source type dashboard parameter.
-
Add Data Source Type Dashboard Parameter: Instead of using the Manual type, add the Data Source type dashboard parameter. This will allow you to restrict the values that the user can interact with.
-
Create User-Based Filter: The next step is to create a user-based filter. This filter should be based on the dashboard parameter used column (for example, CustomerID).
-
Use Dashboard Parameter in Second Data Source: Finally, use this dashboard parameter in the second data source. This will ensure that the dashboard parameter value will be shown based on the user-based filter selection.
By following these steps, you can restrict the values from a dashboard parameter list that a user can interact with. This can be useful in situations where you want to limit the data that a user can view or interact with. For restricting the value of the parameter, you can also use the initial filters.
