On the worksheet which contains the Power Query output data, create three tables with single values in them, (Warehouse, Period From and Period To).



After creating each Table, rename them according to their fields in the Table Design.


Lauch the Power Query Editor, create the parameter and change the name as 'Warehouse'.

Open the Advanced Editor from either the Home tab or the View tab in the query editor. Copy and paste in the following code then press the Done button.


let
    Source = Excel.CurrentWorkbook(){[Name="Warehouse"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Warehouse", Int64.Type}}),
    AndCriteria01 =  Record.Field(#"Changed Type"{0},"Warehouse")
 
   
in
    AndCriteria01


This code represent the applied steps happen on this parameter 'Warehouse'.

-Get the source content from current Excel Workbook, table name as 'Warehouse'

-Change the data type to integer (if needed).

-Then get the value from table row {0}.




Then we do the same steps for the other 2 parameters.

Example:


After applying all the steps above, open Advance Editor for the Query result, and replace the filter of Warehouse and Period with the parameters name as below.




After Close and Load the Query Editor Window.

Now in the Excel File, you can easily change any of the parameters and Refresh All the sources to get the latest data for this report.