URGENT.!! Custom function with dropdown argument

[poornayes]

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.

[Anonymous]

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.

[poornayes]

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.