Data Not Refreshing In Report

[alex4597]

I have a slicer in an hour report that i've built that will no longer refresh after a certain date. Everything else in this report is updated properly but for some reason my hours clocked in won't show anything after 8/16/2020 even though the data is showing as updated.

As you can see on the data tab there are rows with dates after 8/16/2020 so the power bi file is refreshed but the report is not

I've tried refreshing the file, the table, the data model, clearing cache, removing the slicer and making a new one and I still cant get anything after that date to show up in my report. All of my data is pulled from excel.

[amitchandak]

@alex4597 , have created any date table and that table does not have all the dates.

[alex4597]

I have another date table created that has dates for everyday of the year in it and it is linked to this table in the model tab like so

[alex4597 · Accepted solution]

Update: ended up just refreshing an old version of my file and got that one to work