Forum Discussion

AI14's avatar
AI14
Helper III
3 years ago

Date Parameter slicer

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?&" & "...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 (Auckland, Wellington, Christchurch and Dunedin)

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.