Forum Discussion

nishamartis's avatar
nishamartis
Frequent Visitor
9 years ago

To show the data for current day

Hello,

 

I want to show the present day data(Today's data). So I created a calculated column as below and given a visual level filter as AsofToday is 0.

 

AsofToday = DATEDIFF(DATEVALUE(FactTable[Date]),DATEVALUE(TODAY()),DAY)

 

I have implemented this and published it to powerbi.com

As we are collecting data everyday, it needs to be refreshed everyday.  But the problem is when we try to refresh in powerbi.com the data will be showing as BLANK and when we refresh in power bi desktop it shows proper data.

 

Can anyone please help me to resolve this?

 

Thanks in advance.

 

 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    You could try modifying your formula a bit such as:

     

    AsofToday = IF(DATEDIFF(DATEVALUE(FactTable[Date]),DATEVALUE(TODAY()),DAY)=0,"today","not today")

    And then just change your filter criteria, might clear up the zero vs. blank problem.

    • nishamartis's avatar
      nishamartis
      Frequent Visitor
      9 years ago

      Hi,

       

      I have a Virtual Machine environment in Pacific time zone.

      In the morning when I access my VM(I am located in India), and if I refresh my power bi reports I get blank values for data for As of Today. I created measure for todays date(Today = TODAY()) and displayed using score card visualization. Its showing IST time even though we are accessing powerbi.com in VM.

      Can I change the time zone in power.com?