Forum Discussion

svellik's avatar
svellik
Frequent Visitor
6 years ago
Solved

Date format changes between Desktop and Service in time/date filter

Hi    I have a report that is used to 2 years without problems. Last week it started to change format in Serivce to MM/dd/yyyy, instead of dd.mm.yyyy which it is in Desktop.    The report has a p...
Need Help
  • svellik's avatar
    svellik
    6 years ago

    Hi

     

    It didnt work even if I tried more times. 

    Last week it startet to work again for me and all the other users of this report. No changes made on our side. Strange, but as it works I`m happy 🙂

svellik's avatar
svellik
Frequent Visitor
6 years ago

Added some illustration. 

This is the page filter in Power BI Desktop. Correct format, and I can change time. 

Power BI Desktop

 

This is the report page filter in Service when I enter the report. Date does not show:

This is the report in service when loaded

 

This is the page filter in Service after I change the date, it changes in mm/dd/yyyy format, and after I try to change time it blanks out to 01 00 ___.

This is the filter in Service after changed date, and tried to change time

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , svellik 

    I can reproduce your problem here.
     Actually the page filter still works. Just only advance filter card unable to apply dates.

     

     

    And this issue has been recorded and is still being resolved.

    If you want to change the filter setting,here is a workaround :

    Collapse the filter pane and re-expand it. This will reset the advance filter card's bad state.

     

     

     

    Best Regards,
    Community Support Team _ Eason

    • svellik's avatar
      svellik
      Frequent Visitor
      6 years ago

      Hi v-easonf-msft 

      Thanks for the reply. 

      I can see that the work-around resets the filter to default. I can change dates, and yes they work om the report. 

      But I cannot change the time filter(HH and MM). When I try to chang hh or mm then switch to 01:00. 

       

      Is there a temporay work around for the time filter? 
      And is there an ETA for the permanent fix for this issue?

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        6 years ago

        Hi， svellik 

        Try it more times.

        It is suggest to complete the  setting modification at one time and change the  time filter ("HH" "MM")  by typing  rather than  rolling.

         

         

        What I currently know is that fix will be part of 4.2 train. I don’t know the exact time of deployment.

         

        Best Regards,
        Community Support Team _ Eason