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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
hr_tetra
Helper I
Helper I

Weird date table issues 2024

Hi everyone,

 

I have noticed in to different datasets that if a date filter only include 2024 dates, the data dissappears. If I include some dates from 23 the data will be there. If I check the date table all the dates are there. I fixed it in one report by just replacing the date table with a new one, but now I see another report with the exact same issue.

 

Does anyone know what is causing this behaviour and how to fix?

 

Best regards,

 

hr tetra

1 REPLY 1
Idrissshatila
Super User
Super User

Hello @hr_tetra ,

 

make sure there are no filters on the report or the date table has dates for 2024.

 

some date tables are made with calendar function with start and end date, make sure the end date is not 2023.

 

you could use calendarauto function that would give you dates from the minimum date till the maximum in a current model.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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