Dynamic date power query parameter/variable based on user selection at Report level

[MTJT_2000]

Hi All,

I have a transactional table (Synapse as data source) with Employee Join Date as one of the columns.
Expectation will be that users are able to enter/filter for a key date at the report level, and this date will then be passed back to power query to filter for Employee Join Date that is greater than or equals to the filtered date.
How can I proceed with this?

Example as follow:

Full dataset available at Synapse:

Employee ID	Employee Join Date
1001	16/01/2023
1002	24/01/2023
1003	15/02/2023
1004	15/02/2023
1005	21/02/2023

User enter key date as 01/02/2023, only below rows should be loaded into PBI report

Employee ID	Employee Join Date
1003	15/02/2023
1004	15/02/2023
1005	21/02/2023

[Ritaf1983 · Accepted solution]

Hi @MTJT_2000 
The closest option to your description is using power query parameters.

Please refer to this tutorial:

https://www.youtube.com/watch?v=rFI6pc94WdM

The document about editing the parameters in power bi service :

https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.