Dynamic Parameters Creation in PowerBI Using Stored Procedure

I assume you have already nabled dynamic M query parameters?

1. Create a Parameter in Power BI
   1. Go to Modeling > New Parameter > Fields.
   2. Choose DateTime as the type.
   3. Provide a range (start, end, or list of dates if needed).
   4. This parameter will be used in an M Query.
2. Modify the M Query in Power Query Editor
   1. Open Power Query Editor.
   2. Select the table connected via DirectQuery.
   3. Click Advanced Editor and modify the query like this:

let
    Source = Sql.Database("YourServer", "YourDatabase"),
    FilteredData = Table.SelectRows(Source, each [DateColumn] >= DateTime.From(#"YourParameter"))
in
    FilteredData

1. Bind the Parameter to a Report Slicer
   1. To make the parameter interactive:
   2. Create a new table with a column containing datetime values.
   3. Create a slicer using that table.
   4. Bind the slicer to the parameter using Field Parameters.

Please mark this post as solution if it helps you. Appreciate Kudos.