Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |