Date Parameter slicer

[AI14]

Hi

how can i create a date parameter to look at the slicer (single select) and auto populated in my source?

= Json.Document(Web.Contents("https://www.resource.com/api/1.4/reports/hours?&" & "apiKey=123456!&" & "teamId=y22222i&" & "from=2023-06-25&" & "to=2023-06-25&" 

the same should be us style yyyy-mm-dd and have a & at the end.

please help.

Kr

AI14

[Anonymous]

Hi @AI14 ,

You can't use a slicer to change source file, while you can use a slicer to filter the data in your source already connected to.

If you want to use parameters to change source, please refer to

How to Parameterize Data Sources in Power BI | phData

Change the Data Source dynamically in Power BI using Parameters - SqlSkull [6c6b-34e2-3ec-4d39]

How to Configure Data Source Setting Parameters for a Power BI Data Model | Magnetism Solutions | NZ...

Power BI Desktop Query Parameters, Part 1 [e35a-cf54-362-0e0a] (biinsight.com)

Best Regards,

Stephen Tao

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

[AI14]

date parameter connected to slicer.

so when slicer is selected it changes the parameter which then changes to data source.