Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Solved! Go to Solution.
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,
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
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/
User | Count |
---|---|
43 | |
25 | |
22 | |
20 | |
17 |
User | Count |
---|---|
53 | |
45 | |
24 | |
24 | |
21 |