Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Hi @poornayes ,
I would suggest you try parameters to filter data.
How to use Parameters in Power Query in Power BI
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.