Change the Dashboard Parameter value in URL

By using dashboard parameters the user can change the value of the URLs dynamically.

You can pass the parameters to a dashboard by including them in a dashboard URL. Passing parameter values within the URL will apply a filter in the dashboard on the initial load itself.

To set a dashboard parameter within a URL, use the following syntax:

For single parameter:

<parameter1>=<value>

For multiple parameter:

<parameter1>=<value>&&<parameter>=<value>

Using the syntax, you can pass the dashboard parameter value in the URL as follows.

https://<servername>/dashboards/<dashboardid>/<category>/<dashboardname>?&&<parameter1>=<value1>&&<parameter2>=<value2>

Passing Stored Procedure parameter with URL using the Dashboard Parameter

You can pass the stored procedure parameters to a dashboard by including them in a dashboard URL. Passing parameter values within the URL will apply a filter in the dashboard on the initial load itself.

To set a dashboard parameter within a URL, use the following syntax:

For single parameter:

@<parameter>=<value>

For multiple parameter:

@<parameter1>=<value1>&&@<parameter2>=<value2>

For dashboard parameter:

@<parameter>=<@{{:DashboardParameterName}}>

Supported Functions

• IN

• NOTIN

IN and NOTIN operators are supported for URL Filter in dashboard parameter.

NOTE: Parameter name is case sensitive.

Supported Data types

• Character and String

• Numeric

• Date and time

• Binary

For date type parameter values, you can provide the server (where the query will be executed) supported date format as a parameter value.

To append your query string with URL, add a prefix (?) to the query string. If (?) is already there in the URL, add a prefix (&&) to the query string.

https://<servername>/dashboards/<dashboardid>/<category>/<dashboardname>?@<parameter1>=<value1>&&@<parameter2>=<value2>

Using the dashboard parameter syntax, you can pass the dashboard parameter value in the URL as follows.