Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
paulinuk2017
Frequent Visitor

Add 2 date pickers and pass values to stored procedure

Hello

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
1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@paulinuk2017

 

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. 

 

123.PNG

 

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". 

 

234.PNG

 

For your requirement, if you just need to filter records between two days, you can directly use a "Between" Data slicer.

 

Capture.PNG

 

Regards,

 

 

View solution in original post

3 REPLIES 3
v-sihou-msft
Microsoft Employee
Microsoft Employee

@paulinuk2017

 

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. 

 

123.PNG

 

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". 

 

234.PNG

 

For your requirement, if you just need to filter records between two days, you can directly use a "Between" Data slicer.

 

Capture.PNG

 

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

GilbertQ
Super User
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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.