Forum Discussion

q01_1gt's avatar
q01_1gt
Frequent Visitor
6 years ago

Changing time in filter changes also the date

Hi, we are currently facing an issue in our reports. When we try to change minutes in our time filter, it automatically changes also the date of the filter. Reports were not changed in the last wee...
Need Help
sanimesa's avatar
sanimesa
Icon for Post Prodigy rankPost Prodigy
6 years ago

q01_1gtCan you please post a screenshot? The video is not loading, perhaps a bit too large.

  • q01_1gt's avatar
    q01_1gt
    Frequent Visitor
    6 years ago

    Of course, thanks.

     

    This is the filter default:

     

    When we increase the minute, also the date changes simultaneously:

     

    Every time we increase/decrease minutes the date shown in the filter changes from 01/02/2019 to 02/01/2019.

     

    Thanks for your support.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI q01_1gt,

      I test with the latest 64-bit power bi desktop but can't reproduce your issue. What version of power bi desktop are you test?  Can you please share a sample pbix file to test?

      How to Get Your Question Answered Quickly  

      Regards,

      Xiaoxin Sheng

      • q01_1gt's avatar
        q01_1gt
        Frequent Visitor
        6 years ago

        Hi,

        sorry I didn't specify that the issue happens olny when using the report deployed on the web.

        In any case the report has been developed with PowerBI Desktop Version 2.76.5678.782 64-bit, but as previously said the issue is not present in the Desktop app.

         

        The filter corresponds to a field associated to Date type with format dd/mm/yyyy.

         
         

        From the web player when we change the time it also change the date.

         

        Furthermore today I noticed that sometimes the filter behavior seems to consider the date format as mm/dd/yyyy.

        For example if I open the calendar selection I can see dates of the current month:

        If I select for example 1st of May (01/05/2020 in dd/mm/yyyy) is then shown as 05/01/2020:

        And if I open again the calendar it shows dates of January, as if I previously selected 5th of January instead of 1st of May:

         

        My pbix connects to external datasource so I believe I am not able to share it with you.

         

        Best regards