From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Create and modify parameters

Create and modify parameters - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Create and modify parameters

“

- [Instructor] In this sub lesson, we're going to create and modify parameters. So first off, what are parameters? Parameters serve to easily store and manage a value that can be reused. Parameters give you the flexibility to dynamically change the output of your queries depending on their value. Parameters can be used for changing the argument values for transformations of data source functions or inputs in custom functions. Some common use cases for parameters are step arguments, custom function arguments, and they're also great for pathing, and later on, you'll see their use in Incremental Refresh. So let's get ourselves over to the Power BI Desktop. Okay, so I am on the Power BI Desktop. What I'm going to do is take this file and I'm going to go over to the PowerPoint editor. And what we'll see is down in the left-hand side in the queries pane, we've got something called pFilePath, which is set to my C Drive\PL-300, and something called pYearSelector, which currently is set to…

Contents