Quick summary
Power BI parameters let you create dynamic, reusable values inside Power Query that filter and shape your data without hardcoding. Using the Manage Parameters dialog, you can define a parameter's name, type, and value in minutes and reference it directly in any Power Query step.
Steps
- Click Transform data to open the Power Query Editor.
- Click Manage Parameters in the toolbar.
- Select New Parameter to begin creating a parameter.
- Set a name for your parameter.
- Set the type and value of your parameter.
- Click OK to save and confirm the parameter.
- Use your newly created parameter inside a Power Query to make your data transformations dynamic.
