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 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 URL as follows.

Default parameters

Default parameters enhances to filter the data based on the current user. It can be passed in custom query and web URL. Currently, the default parameter is supported with,

• Full name

• Email

For the current user, use the following syntax to filter the data based on full name.

Syntax: @{{:CURRENTUSER.FULLNAME}}

For the current user, use the following syntax to filter the data based on email.

Syntax: @{{:CURRENTUSER.EMAIL}}

Default parameter in custom query

Include the default parameter by pressing the key Shift+2, to list the default parameter along with the available user defined parameters. You can use it anywhere in query editor window.

Another way is, user can manually type the default parameter in code view using the following syntax.

Default parameter in web URL

You can include the default parameter in the web URL with live connection using the following syntax.

Here, Sales Analysis Dashboard is rendered for two users with full name ALFKI and BERGS. The default parameter is applied as follows.

For the user ALFKI, the dashboard will be rendered as follows.

For the user BERGS, the dashboard will be rendered as follows.