Syntax for Referencing Parameters

Use the syntax provided to reference parameters from a workbook visualization's properties, SQL expression, tooltips, or calculations.

To reference a parameter use:

@parameter("parameter name")('default value')

This table contains expression syntax examples:

Parameter Expression	Description
@parameter("Supplier")('Brembo')	References the Supplier parameter. The parameter value is 'Brembo' unless the Supplier parameter is passed into the workbook via data actions or URL parameters. In that case, the parameter value is set by the data action or URL parameter.
@parameter("StartDate")(DATE'2021-10-08')	References a parameter named StartDate with a default date of October 8, 2021.
@parameter("CurrentTime")(TIME'18:00:00')	References a parameter named CurrentTime with a default time of 18:00:00.
@parameter("CurrentDateTime")(TIMESTAMP'2023-02-28T18:00:00')	References a parameter named CurrentDateTime with a default date of February 28, 2023 and a default time of 18:00:00.
@parameter("NumOccurrences")(5)	References a parameter named NumOccurrences with a default of 5.
@parameter("SelectedColumn")("A - Sample Sales"."Offices"."D2 Department"')	References a parameter named SelectedColumn, and defaults to "A - Sample Sales"."Offices"."D2 Department".
@parameter("Supplier", style="delimited", separator="/")('Brembo','Bosch')	References a parameter named Supplier, and the value defaults to "Brembo/Bosch" when used.
@parameter("Supplier", style="individual")('Brembo','Bosch')	References a parameter named Supplier, and is used by data actions to separate parameters: &myParam=Brembo&myParam=Bosch
@parameter("Supplier", type="alias")('Brembo','Bosch')	References a parameter named Supplier and uses any configured alias values, if they exist. If Alias is On but no alias is provided, it uses the available values instead.
@parameter("Supplier", type="value")('Brembo','Bosch')	References a parameter named Supplier and uses any configured values, regardless of whether an alias is configured.