Forum Discussion
Add 2 date pickers and pass values to stored procedure
Is it possible to place 2 date pickers into a report then add a button
I can then call a stored procedure and show it’s data?
My user wants to compare a set of values between 2 days
Paul
Based on your description, it seems you want to apply query parameter in your stored procedure to retrieve data. We are able to use the query parameter to retrieve data.
However, it's not possible to populate a date picker into query parameter. And we can't only use "Query" type parameter in a query, which means we have to use "Any Value" or "List of Values".
For your requirement, if you just need to filter records between two days, you can directly use a "Between" Data slicer.
Regards,
3 Replies
- GilbertQ
Super User
Hi paulinuk2017
What I have done in the past is to have all the data in a dataset and then by using Dynamic Filters and slicers getting the values selected and then using them to do a comparison.I do have a blog post that relates to Change Tables, and the only difference is that you would use the dates as what you wanted to compare in the Change tables.
https://www.fourmoo.com/2017/08/22/power-bi-using-change-tables-to-compare-data/
v-sihou-msftMicrosoft Employee
Based on your description, it seems you want to apply query parameter in your stored procedure to retrieve data. We are able to use the query parameter to retrieve data.
However, it's not possible to populate a date picker into query parameter. And we can't only use "Query" type parameter in a query, which means we have to use "Any Value" or "List of Values".
For your requirement, if you just need to filter records between two days, you can directly use a "Between" Data slicer.
Regards,
Could you please reply in brief I had same kind of situation but I had no date field on main query how can I do this. I need a seperate slicer that is going to call the proc parameters which should be same startdate and enddate. StartDate would be the starting day of year and enddate is todaysdate
