Power Query - Faster & Easier Parameters

Create robust, easy-to-use, and SUPER FAST Parameter tables for more dynamic reporting.

File Download Link:

00:41 Common Method for Collecting Parameters
06:10 Robust Parameters with Mixed Data Types
11:44 Custom Interface Sent to Parameters

[ariarc]

I've heard other instructors take on the issue of parameters in other ways, and yours is a lot easier to understand and robust. Also, your pacing and clarity is EXCELLENT. I love your teaching style and have become an immediate follower. I will also look for any courses that you may have. Thank you very much.

[Swizzletwice]

Excellent video! I had no clue what I was doing, but I was able to follow every click. The explanation was thorough, concise, and articulate and presented in a nice tone of voice.

[MaydayAggro]

You just created so much work for this perfectionist Excel user.

[michaeldingee]

Your channel has the most unique solutions to several different platforms. I took your sample file and added 2 different ways to use your parameters selections. Used the new Filter Function and Groupby. I also created another panel using checkboxes. I checked one of my customers to see what they had in their Current version of 365. They had Checkboxes and Filter. I used the Let function for Checkboxes and Filtering. I can send you a copy if you wish to see what I have done and maybe for your subscribers how to improve or share.

[dougmphilly]

subscribed because this deserves a nobel prize. i have so many uses for from this.

[shirsN]

Man i loved this video a lot. I was using multiple 2 rows filters like from 2017, the time when i started using this hidden gem PQ. And after these many years i understood this amazing way of filtering.❤. Its a game changer for me. As i apply like 4 5 different filters in one sheet, so had create like 4 5 different connection queries. So my query tab has lot of queries which is a different issue, but i am basically missing a simplified approach.

Well this is very exciting.
Also, there are many other experts on PQ and yet they have almost not covered this way filtering

[StefanoVerugi]

outstanding tutorial, clear, concise and yet thorough, I am very appreciative of your work, thanks

[MrJunaidtayyab]

Man. Parameters is not an easy topic but the way you explained ❤

[zahoorsarbandi]

really very informative lecture and helpful in daily work. Explanation is remarkable. Thanks

[kebincui]

Excellent Video. Cristally clear and elegantly presented. Looking forward to more advanced power query videos like this. Thanks for sharing 🌹👍

[ScottRobertson-jt]

This deserves a lot more like and subs. Excellent tutorial and examples.

[vwij]

Great video. The ideas can used in an interactive dynamic way in varied contexts with the illustrated PARAMETER approach. Thank You.

[robbe]

Magnificent video and explanation.
I personally will change my method of filtering Data tables to this one instead of using slicers.
Top, top, top!!

[vijayarjunwadkar]

I just chanced upon your video and I must say, it's fantastic! I will check the other videos too. Thanks a lot for your channel, wishing you all the best and lot of success!

[jazzista]

What a great explanation and elegant at the same time without much Mcode. Thanks for the idea. I have a handful of queries pulling from SQL that I wanted to create parameters to bring the required data. Thanks for such a great posting. You are the best source in YT for Powerquery.

[MsMikeful]

Very clear instructions, easy to follow. I noticed you clicked on the running man to perform the refresh, can you please share how you do that also?

[davidfamilydoctor]

Brilliant. my current query with parameter table, then split into five separate queries, then drilled down to the respective parameter. This way from BCTI is much, much simpler. Requires familiarity with referencing table rows, though.

[fabianmolyneux]

Thank you. This is excellent presentation. You make it easy to follow along.

[markhenderson]

Clear and concise. Thanks. Very helpful.

[LosoIAm]

In boxing, this video would have been a knock-out punch!

We used a similar trick in designing Microsoft Access forms/reports where referenced fields are hidden.

Thank you so much.