Forum Discussion
Getting value of date slicer
Dear all,
I am quite new in Power BI and searching to find a workaround for my project in which I am stucked. Here is the case:
I would like to exhibit some screeenshots to my colleagues in the company. These screenshots were uploaded to sharepoint library with flight date. What I would like to have is to generate a filtered (according to flight date) URL on report which has a date slicer. The trick is that I want to have the date values in slicer so that I can generate a dynamic URL and make my colleagues to reach the screenshots for the dates which they select on report.
I hope I am clear to tell my case. Your need is highly appreciated.
Thanks in advance.
HI syilmaz,
AFAIK, you can't send value from slicer/filter to query editor level, please use query parameter to instead.
Deep Dive into Query Parameters and Power BI Templates
BTW, query parameter not available on power bi service.
Regards,
Xiaoxin Sheng
3 Replies
- Phil_Seamark
Microsoft Employee
Hi syilmaz
Do you mean something like this?
https://docs.microsoft.com/en-us/power-bi/service-url-filters
Hi Phil_Seamark,
Thank you for your response. Actually it is not the Power BI service URL, I meant to have a dynamic URL for a sharepoint library. Please take a look at the below link:
https://qazxcdswer.sharepoint.com/SSLibrary/Forms/AllItems.aspx?FilterField1=FlightDate&FilterValue1=12/23/2017&FilterOp1=Lt
I want to insert this URL to power bi reports, however it should be date filtered in accordance with the users selection from date slicer (for the above URL, upper boundary for slicer is 12/23(2017).
HI syilmaz,
AFAIK, you can't send value from slicer/filter to query editor level, please use query parameter to instead.
Deep Dive into Query Parameters and Power BI Templates
BTW, query parameter not available on power bi service.
Regards,
Xiaoxin Sheng
