Populate a Power BI parameter list using a query

Patrick shows you how to populate a Power BI parameter list using a query. This can help you avoid manually entering a list, or just having free text.

********
LET'S CONNECT!
********

***Gear***

#PowerBI #Parameters #GuyInACube

[BrianBullington]

I love when I'm trying to solve a very specific problem, and I come across the perfect video walking me through it. Thanks!

[lenac]

This is GOLD!! YO!! Was trying to get the Query in Parameter setup to work but gave up until now. Much respect, brother. Your tutorials have helped me so much.

[nataliyar]

Is there a way to use multiple values from the list? I need to be able to select 4 or 5 values at the time. working with PowerQuery

[johngeiger]

Outstanding! Glad I discovered this video, Patrick. Can be used in many applications. Thank you!

[christophertauss]

Really good video. I am somewhat new to Power Query and am working with Excel (rather than Power BI). I need to take a table; filter it for ids I need to look for; then go back to the original table and filter rows with those IDs. A bit odd, but I will try something like this. Great job explaining a powerful concept.

[MG-]

Love your videos, you guys are one of the reasons that PowerBI is so good

[ashleyzhang]

Thanks so much Patrick! It helps me a lot! Question: Is there a way to allow no selection of the parameter so the visualisation plots are based on all data after I set up the dynamic parameter filtering? Like a "All" option on top of the parameters

[santoshpaidi]

Thanks for wonder videos. I like your statement patrick
"I am not lazy, I am efficient".

[jainbhavesh]

@Patrick Thanks for this video, i was looking for this and you explained precisely. is there any way to user hierarchy in parameter? without using any plugins

[allardbon]

Great explanation, Patrick! Thanks a lot! (Allard from The Netherlands)

[ferresferres]

Love you Patric you got the best youtube power bi tutorial !!!!

[DriekWorks]

@Patrick; very useful thanks; question: in my model I have a folder query in which a parameter is used to bring the files together, now in my template is also listing that parameter at the start; is there a way to chose what parameter to prompt at opening the file?

[peterkoel]

This is an awesome video. It answered a number of questions on lists and parameters. Do you offer any structured Power Bi training?

[willbee]

I am pretty new to PBI but have really enjoyed your videos, but this one is going over my head; why is this better than a simple filter on the filters pane over on the right or putting a slicer on the page? Thank you.

[pietervandermerwe]

Awesome stuff, tried but never transformed to list, now I know and will implement.

[chaitrajain]

Hi @Patrick Thanks fot the video.I am working getting a percentage column as dynamic parameter but it's not completely working ..Please suggest any video to go through on ddynamic percentage parameter

[ouyuukf]

Hi! @Patrick, how can I implement date or timestamp values to list? Are there any date or calendar features instead data from another table?

[pmack]

Third time back to this one! Really useful

[Unbox]

Thank you! Great example and so clear!

[JurgensvanEeden]

Hey Patrick thanks for all the great content. Was hoping you could help me solve something similar. I use parameters to update connection details for a specific report but I want get a way for the report to read either the folder it's stored in or the workspace it's published it to determine which parameter details to use. If I can just find a way to pass the workspace name into power bi I can set the parameter details accordingly to change the connection parameters? Please help?