How to bring the StartDate and EndDate to a slicer in power bi.

Thank you very much for your detail explanations. 

Since there is no proper date filed in my stored procedure, it looks like I need to modify the sp first to have a proper date field. In that case, I can use this date field to join with a date table. Some consultant expert built this complex query and I can't even understand it, due to its complexcity. That is the problem right now.

However, is there a way without a date field in my dataset to pass the StartDate and EndDate parameters in power bi ?  This the stored procedure sample;

Exec SSRS_Project_v2 @StartDate = '2016-1-1', @EndDate = '2023-12-5'

Thanks again for your assistance, Appreciated.

PT

First, make sure that the dates returned by your stored procedure are loaded into Power BI. You might need to modify your stored procedure to include a date range or extract the dates you need.

Open the Power Query Editor and check if your date range is loaded into your data model.

1. Data Model:

   • After loading the data, go to the data model (Diagram View in Power BI Desktop).
   • Confirm that the date range is present in the data model.

2. Create a Date Table:

   • If your stored procedure doesn't return a date table, consider creating one in Power BI.
   • You can use the "New Table" feature in Power BI to create a date table with a range of dates that covers your data.

3. Relationships:

   • Ensure that there is a relationship between your main data table and the date table based on the date fields.

4. Slicer:

   • Create a new slicer visual on your report.
   • Use the date column from the date table as the slicer.

5. Use Slicer in Report:

   • Now, you can use the slicer to filter your visuals based on the selected date range.

6. Dynamic Date Range:

   • To make the slicer dynamic based on the selected dates, you might want to create measures that use the selected dates from the slicer.
   • Then, use these measures in your other calculations.