From Multiple Excel sheets with multiple dates that have values (KPI)

Hi ssylvester 

From the screenshot you shared, it looks like your data has a separate date column for each month (e.g., Date January, Date February, etc.). This structure is not suitable for Power BI and will not work properly with filters or a Date table.

If this layout came from combining multiple Excel sheets, you likely merged them by columns — but in BI we usually need to append them as rows instead.
If you received the file this way and can't change the format, you’ll need to unpivot the monthly columns in Power Query to get a proper "Date" column and "Value" column.

Only after that will filters and relationships with a Date table behave correctly.

Detailed guide abput appending here:

https://www.youtube.com/watch?v=1cPtk-8iK0k

Unpvot :

https://www.youtube.com/watch?v=d__rMVOgo40

To get more specific help, please upload your .pbix or Excel file to a public cloud service (such as OneDrive, Google Drive, Dropbox, etc.) and share a link here so we can take a closer look and assist further.