Forum Discussion
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
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
To get more specific help, please upload your
.pbixor 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.
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
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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.