Parameters

The parameter is a dashboard element that allows to dynamically influence the “Expression” highlight rule.

In order to create a parameter, click the toolbar icon:

The following window opens:

To add the parameter, click the «Add» button. The following parameters are displayed in the window:

• Visible – specifies whether or not the parameter editor is visible in the dashboard Parameters dialog;
• Allow Null –specifies whether or a not null value can be passed as a parameter value;
• Allow Multiselect – specifies whether or not multi-selection is enabled for the current parameter. The following limitations are applied to parameters with multi-selection
  • Use the “is any of” or “is none of” operators to pass a multi-select parameter to a filter criteria or to the Expression format condition.
  • Use the “In” or “Not In” operators to pass a multi-select parameter to a calculated field
  • Custom SQL queries do not support multi-select
  • Stored procedures used in SQL and Entity Framework data sources do not support multi-select parameters.
• Name – Specifies the parameter name:
  • A name can contain letters, numbers and
  • A name cannot contain
  • A name cannot be an empty
  • The dashboard cannot contain parameters with the same
  • Names are case-sensitive. For example, you can create the names Parameter and PARAMETER.
• Description – specifies the parameter’s description displayed;
• Look-Up Settings – specifies the parameter’s look-up editor settings;
• Type – specifies the parameter type;
• Value – specifies the default parameter’s value(s).

Note that when “Allow Multiselect” is set to “true”, the “Value” option allows you to select multiple parameter values.

Let us create a setting that highlights the “Reseller Sales Amount” value of more than $500,000, but less than $ 1 million for all product subcategories.

First, we add a table with the following values:

Create two parameters and fill in the fields as follows:

For “Reseller Sales Amount”, create an “Expression” highlight rule with the following parameters:

As a result, the first parameter from the list is displayed in the value field:

Similarly, double-click the second value field:

The first parameter will be displayed again, click it and select the “Sales2” parameter in the opened list:

It is only left to choose the color of highlight on the panel:

Now all the values of the “Reseller Sales Amount” measure that are higher than $ 500 000 but lower than $ 1 million for all product subcategories are highlighted in the table:

Now let us change the range of values: Sales1 = $ 200 000, and Sales2 = $ 2 million.

For this, click the “Parameters” icon in the toolbar:

In the opened window enter the corresponding values for each parameter:

As a result, we get a table where all the values of “Reseller Sales Amount” measure for more than $ 200 000 but less than $ 1 million are highlighted: