I've about halfway through the "Visualize school library data with Power BI" section and refreshed my loans data this afternoon to pull through overdue loans.
Since then my matrix is only pulling through loans from Nov, Dec, Jan, Feb & Mar for each school year and any loans without dates in these months are in a section on their own.
I've also been looking at the data in the loans table that was pulled down from Dataverse, just to make sure there are loans that started in May and there are multiple records with Due Dates earlier than the loan start date.
My tables are connected dimDate Date to Loans Date Loan Start as per the video.
Any ideas what may have caused this or how to fix?