All courses available in-class or via remote login

Query parameters

Using parameters in Power Query

September 13, 2017

Power BI and Power Query

In this article we will show you how to use parameters within Power Query in PowerBI. Query parameters are a powerful way to dynamically interact with your data in Power BI. With the query parameters, users can define one or multiple parameters to be used in their queries. Stay tuned while we work through this exercise to demonstrate how query parameters work.

Consider a query with geographical information in it like Country, State, and City:

As you can see the query contains information on state and city names from a few countries across the globe. We would like to just focus on Europe and hence we would create a parameter to define a list of all the countries in Europe. We have already created a list query called Europe which we will use when we create the parameter.

Under the Home menu click on Manage Parameters to bring up the Parameters window:

excel exert

Enter the data in the relevant sections like below and hit OK.

excel exert

A new parameter EuropeanCountries is now created which we can now use to filter the query. Click on the Filter option in the Countries column and go to Text Filters-> equals… to bring up the Filter Rows window. Select Parameter instead of Text to choose the EuropeanCoutries parameter and hit OK.

excel exert

Since we set the current value of the parameter to be Germany the query now lists only data from Germany

excel exert

You can now dynamically update your charts by changing the current value. In the data model go to Home-> Edit Queries-> Edit Parameters to bring up the Enter Parameters window. From the drop down list choose the country you want and the query and any chart/table which references the Country field will be updated

excel exert

This is just one example of how you can use parameters.

View Power BI Courses

Contact Us

What is Remote Training?

Valued by Individuals

Over 22963 Reviews
It is the 1st time that I use Power BI and at the end of the training session I have gained a good knowledge. Ken was organised and helpful. -Power BI Beginner Canberra
Kumara - Power BI Beginner, .
Very helpful and easy to understand. -Excel Advanced Perth
Bennett - Excel Advanced, .
Another great workshop with Dom, always helpful and keeps things exciting. Very knowledgeable and a great teacher. -Excel Advanced Perth
Felix - Excel Advanced, .
Learnt so much! -Excel Advanced Perth
Shay - Excel Advanced, .
Excellent course. Well delivered and informative. -Excel Advanced Perth
Stephen - Excel Advanced, .
Great course and instructor! -Excel Advanced Perth
Tara - Excel Advanced, .
Thank you Michael. You are Very supportive, I hope with your little help I will be able to put my BI training to real use Best Regards, -Power BI DAX Sydney
Gurwinder - Power BI DAX, .
A great course - covered a lot & Michael is very knowledgeable & patient! -Power BI DAX Sydney
Lauren - Power BI DAX, .
Lot of content, Michael was easy to follow and very helpful. I have lots to take back to work an d practice. I note that we didn't go through the book as it is laid out and there are probably a lot of exercises that we didn't get time to do. I expect that this will need to be done in our own time later. I think this course can be stretched over 2 days. -Power BI DAX Sydney
Fiona - Power BI DAX, .
Very useful course and excellent tutor. Keen to know more about DAX Studio. -Power BI DAX Sydney
Lina - Power BI DAX, .
Great trainer, really engaging which is difficult in a virtual environment. Covered a lot in one day, and looking forward to the next course. -Power BI Beginner Adelaide
Kelleigh - Power BI Beginner, .
Jagg explained everything clearly and in a very logical order which helped with understanding the intricacies and end result of the package. He handled the hybrid teaching environment (online and face to face) very well. -Power BI Beginner Adelaide
Suranie - Power BI Beginner, .
Well paced, easy to follow, engaging presentation -Power BI Beginner Adelaide
Nathaniel - Power BI Beginner, .
Good tutorial class. Learnt a lot! -Power BI Beginner Adelaide
Julian - Power BI Beginner, .
A great foundation for an introduction to Power BI. -Power BI Beginner Adelaide
Jason - Power BI Beginner, .
-Power BI Beginner Adelaide
darren - Power BI Beginner, .
This course was very informative for someone who is very familiar with Excel and self-taught but wanting to fill in the gaps and expand their knowledge even more. Steven was a brilliant trainer - he spoke clearly and slowly (which really helps when doing this course online) and made sure that everyone in the session was following each step. And his virtual chocolate frogs were much appreciated! Thank you so much! -Excel Advanced Brisbane
Rebecca - Excel Advanced, .
Good Introduction to advance features, would like to extend to the next level which is probably more aligned to the specialist courses. Key Goals achieved - 7 efficiency options in modelling identified. -Excel Advanced Brisbane
Robyn - Excel Advanced, .
Stephen was easy to follow and doing it on line was a great experience. -Excel Advanced Brisbane
Helen - Excel Advanced, .
Steven was a fantastic teacher - explained things clearly and checked in. His also took the time to find out what we do for work and try to tailor what we focused on based on those needs or highlight when what we were learning may be especialy applicable to certain people. The course is great with the resources to play with - i got a lot out of it Virutal chocolate frogs for Steven! -Excel Advanced Brisbane
Shakira - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia