Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
nickspizza
Helper I
Helper I

Date Slicer/Filter showing wrong data on previous day

This is very strange so I will try to simplify my problem and hopefully it makes sense.

 

When I change the date filter to the first of October then it shows the correct data. This is the same for all the days up until the 12th.

But when I change it to the 13th (yesterday) of October then it shows a number that is close to 10 times higher than what it should.

When I change the date to the 14th then it's correct as well as the 15th onwards.

 

I went to the data and confirmed that the problem is not there by filtering it, but now I don't know where to go. 

 

Edit: The above and below refers to how it looked like on the 14th, showing the wrong data for the previous day (13th). When I open the report today (15th) then it shows the incorrect data for the (14th) but the correct data for any other filtered day. So it keeps showing the wrong data for yesterday but not for any other day.

 

filterdesktop.png

Screenshot (115).png

1 ACCEPTED SOLUTION

I had to delete the slicer and create a new one to fix the problem

View solution in original post

3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

Hi, @nickspizza 

 

Is TM LTE TGT a measure or column? Is the result correct in desktop?

If problem still persists, pls let me know.

 

Best Regards,

Community Support Team _ Janey

 

I had to delete the slicer and create a new one to fix the problem

lbendlin
Super User
Super User

Keep in mind that the Power BI Service runs on UTC.  Check your measures to see if they assume local timestamps.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors