Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
poornayes
Frequent Visitor

URGENT.!! Custom function with dropdown argument

Hi all,

I am new to power query. I want the end user to select a value from dropdown when the custom function is invoked. And based on the selected value the internal implementation will be handled.

Example, The user has to select a month when invoking the custom function. With the selected month(text), the dataset has to be fetched.

 

Thanks in advance,

Poorna.

2 REPLIES 2
Anonymous
Not applicable

Hi @poornayes ,

 

I would suggest you try parameters to filter data.

How to use Parameters in Power Query in Power BI

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI-Blog | Microsoft Power B...

Creating Dynamic Parameters in Power Query - Excelguru

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi, 

The dropdown which i asked is to construct the web url to get the web content. Based on the dropdown input, the url will be constructed. 

I hope the parameters is for filtering after the web content is received.

 

Thanks,

Poorna.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.