Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Issue with dates filters

Hi Expert   I have managed to write most the DAX for the URL filtering and all of the formula is working fine up until the point where the data filter oDAte kicks in. then nothing happens when i cl...
Need Help
Sergiy's avatar
Sergiy
Resolver II
7 years ago

Hi Anonymous ,

 

Your measure generates the following link:

https://app.powerbi.com/groups/6a4fa620-97e6-425b-ba79-1c9b9c209e68/reports/69ce2f6f-8fd7-4b5f-a758-98cbbb0064b6/ReportSectiond77d965cc24737ab52b1?filter=DIMSalesPerson/OfficeLocation eq 'USA' and DIMSalesPerson/City eq 'Seattle' and DIMShipper/ShipCompanyName eq 'United Package' and DIMProduct/CategoryName eq 'Dairy Products' and DIMSalesPerson/SalesPerson eq 'Davolio, Nancy' and DIMSalesPerson/SalesRegion eq 'WA' and Calendar/Date le 5/28/2017 and Calendar/Date ge 5/20/2015

 

According to Docs you are expected to use 'YYYY-MM-DD' or 'YYYY-MM-DDT00:00:00' date format:

https://docs.microsoft.com/en-us/power-bi/service-url-filters#date-data-types

 

I'd try changing date format.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Experts Inc Micorsoft team thank you very much. i see the error. much appericated for the excellent feedback as always.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Sergiy and Lin

     

    I have chnaged the date time format as you have shown in the question. but i am still getting the following error when clicking the hyperlink. The hyperlink goes to power BI services but does not filter the report as there still appears to be a date error. i have changed the ate format in Power Query accordingly.

     

    • Sergiy's avatar
      Sergiy
      Resolver II
      7 years ago

      Anonymous 

      Have you used quotes as in the example Docs provided?

      Table/Date gt '2018-08-03'.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Sergiy

         

        VAR oDate = if(ISFILTERED('Calendar'[Date]), "Time/Date le "  & FORMAT(MAX('Calendar'[Date]),"YYYY-MM-DD") & " and Time/Date ge " & FORMAT(MIN('Calendar'[Date]),"YYYY-MM-DD"))

        how would you add quotes here, unless i am beng silly. I changed teh date format accordingly, but how do you get the quotes??

        thannks.. 

        i can see from my web URL there are no quotes on the date parameter.