Forum Discussion
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?&" & "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
2 Replies
- AI14Helper III
date parameter connected to slicer.
so when slicer is selected it changes the parameter which then changes to data source.
- AnonymousNot applicable
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]
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.