Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

To show the data for current day



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.




I have implemented this and published it to

As we are collecting data everyday, it needs to be refreshed everyday.  But the problem is when we try to refresh in 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.



Super User
Super User

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.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...



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 in VM.

Can I change the time zone in



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors