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 page filter with date and time of day. Time of day shows with AM/PM in both Desktop and Service. 

Now in Service when useres change date it shows like 04/27/2020, and they can no longer set the time(hh:mm) in the filter, as it blanks out when the change it. 

 

Settings in pbix, serivce and Chrome all set to norwegian.


Any idea what has happend and how to fix?

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 🙂

5 Replies

  • 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?