Forum Discussion
Using Parameters to bring dynamic data
Hi Anonymous ，
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create query parameter
2. Add filter
= Sql.Database("xx", "xx", [Query="select * from xx where Page_URL='"&Page&"' "])Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Solved: Use table values as a parameter - Microsoft Fabric Community
3. Change the parameter name
Best Regards
Hi Anonymous ，
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create query parameter
2. Add filter
= Sql.Database("xx", "xx", [Query="select * from xx where Page_URL='"&Page&"' "])
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Solved: Use table values as a parameter - Microsoft Fabric Community
3. Change the parameter name
Best Regards
Thanks for sending this, but how would you set it up so that a user can click a selection from a filter or table and have the filtering occur, based on which one the user chooses?