Forum Discussion

syilmaz's avatar
syilmaz
Frequent Visitor
8 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

syilmaz's avatar
syilmaz
Frequent Visitor
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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