| title | description | ms.date | ms.service | ms.subservice | ms.topic | author | ms.author | ms.reviewer |
|---|---|---|---|---|---|---|---|---|
Add or modify default values for a Power BI paginated report parameter | Microsoft Docs |
Use these steps to customize your reports with added, changed, or deleted default values for Power BI paginated report parameters. |
01/23/2023 |
powerbi |
report-builder |
conceptual |
maggiesMSFT |
maggies |
saurkumar |
[!INCLUDE applies-yes-report-builder-no-desktop]
After you create a Power BI paginated report parameter, you can provide a list of default values. If all parameters have a valid default value, the report runs automatically when you first view or preview it. In this article you learn to add, change, or delete default parameter values.
Report parameters can represent one value or multiple values. For single values, you can provide a literal or expression. For multiple values, you can provide a static list or a list from a report dataset.
-
In the Report Data pane, expand the Parameters node. Right-click the parameter and click Edit. The Report Parameter Properties dialog box opens.
[!NOTE]
If the Report Data pane is not visible, click View and then click Report Data. -
Click Default Values.
-
Select a default option:
-
To manually provide a value or list of values, click Specify values. Click Add and then enter the value in the Value text box. You can write an expression for a value. The data type must match the data type of the parameter. Field names cannot be used in an expression for a parameter.
For multivalue parameters, repeat this step for as many values as you want to provide. The order of items you see in this list determines the order that the user sees them in the drop-down list. To change the order of an item in the list, click the Value text box to select the item, and then use the up and down arrow buttons to move the item higher or lower in the list.
-
To provide the name of an existing dataset that retrieves the values, click Get values from a query. In Dataset, choose the name of the dataset.
In Value field, choose the name of the field that provides parameter values.
-
-
Select OK.
-
In the Report Data pane, expand the Parameters node. Right-click the parameter and click Edit. The Report Parameter Properties dialog box opens.
-
Click Default Values.
-
In Select from one of the following options, click No default value.
-
Select OK.
- Add Cascading Parameters to a Report (Power BI Report Builder)
- Tutorial: Add a Parameter to Your Report (Power BI Report Builder)
- Parameters Collection References (Power BI Report Builder)
- Change the Order of a Report Parameter (Power BI Report Builder)
- Add, Change, or Delete a Report Parameter (Power BI Report Builder)
- Expressions in Power BI Report Builder