cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
syilmaz Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Getting value of date slicer

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Super User
Super User

Re: Getting value of date slicer

Hi @syilmaz

 

Do you mean something like this?

 

https://docs.microsoft.com/en-us/power-bi/service-url-filters


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

syilmaz Frequent Visitor
Frequent Visitor

Re: Getting value of date slicer

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). 

Highlighted
Community Support Team
Community Support Team

Re: Getting value of date slicer

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |