How to remove quotes in dashboard parameter values in Bold BI?

When working with dashboard parameters of string data type in queries, you may encounter an issue where the parameter values are passed within single quotes. This can be undesirable in certain scenarios. This article explains how to remove the single quotes in the dashboard parameter value.

Solution

To remove the single quotes from the string data type parameters in your queries, you can utilize the Ignorequotes parameter. By enabling this parameter, the quotes will be ignored, allowing you to pass the values without them.

Steps to Implement

1. Identify the dashboard parameter that is causing the issue.

2. Modify your query to include the Ignorequotes parameter instead of the direct parameter.
   

   

3. Test the query to ensure that the parameter values are now passed without single quotes.

Related Links

• Dashboard parameter documentation