NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

Power BITutorials

How to Manage Parameters in Power Query

1 Mins read

Learn How to Manage Parameters in Power Query Step-by-Step.

Power Query can create a query parameter and link it to the List Query. This is one of the most unknown features of Power Query. Let us study this unique feature along with an example. We have considered the same example of the list query explained above.

Manage Parameters By Power Query

 

Step 1: Create a List Query to Manage Parameters

We have created the list query using ‘Add as New Query’ option in Power Query as shown below. To manage the parameters, you have to first create a list query as we have created above. Let’s consider the same example here also.

CREATE A LIST QUERY TO MANAGE PARAMETERS

Step 2: Select Manage Parameters option

To select Manage Parameters option in Power Query, go to-

Home  >  Manage Parameters  >  Manage Parameters option

MANAGE PARAMETERS IN POWER QUERY

Step 3: Close & Apply

This is how you can create new parameters using Manage Parameters feature. Power Query creates a new query where you can view the current value that you had specified. To change the current value, just click on the Manage Parameter option and go back to the window to change the value. After you finish with all these transformations, click on Close & Apply button to save the changes.

AFTER CREATING A NEW PARAMETER

Want to become an expert in Power Query? Check our Premium Quality Power Query Course with instructor-led live training and high-quality videos. 

You can learn more : 

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…