Forum Discussion

lordtopcat's avatar
lordtopcat
Icon for Helper I rankHelper I
6 years ago

Relative Date - In this day showing yesterday's data?

Hi,

 

My first time using the relative date filter function - when I select "Is in this day", the date populated is yesterday?

 

 

How can I make it so that is shows today's date and not yesterday's?

 

Cheers

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    In the image, it is showing April 14th, 2020, that's today in my time zone, is it not in yours?
    • lordtopcat's avatar
      lordtopcat
      Icon for Helper I rankHelper I
      6 years ago

      Oh sorry, should have stated I am in New Zealand - today is the 15th.

       

      I'm wondering if irrespective of the regional settings in Power BI, the relative date filter function somehow doesn't know my timezone?

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, lordtopcat 

     

    I created data to reproduce your scenario, and then I modify my timezone to New Zealand. I got the same result as yours.

     

    It seems that there is some problem  when the relative date filter identifies the timezone. I'd like to suggest you create a support ticket for the issue here .

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.