Forum Discussion
Enabling parameter in Desktop
Hi All,
I have a situation where I have a query where I have declared the start date and end date in the query, when I run the complete query on Power BI it gives me the output but I want to change the filters i.e start date and end date on Power BI end only and also wish to have the same as filters or if possible wish to use them as slicer.
Please let me know how to go about the same.
2 Replies
Anonymous , you can use Power query parameters. But I doubt you can use a slicer on that. If is direct query, you can think of dynamic M parameters
Hi Anonymous ,
It's not supported to pass the slicer value to SQL statement.
Check if query parameters in Power BI Desktop suits your needs.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
https://reevessmith.wordpress.com/2014/08/19/power-query-and-stored-procedures-with-parameters/
Best Regards,
Jay
