Forum Discussion
From Multiple Excel sheets with multiple dates that have values (KPI)
HI all,
Please could anyone kindly assist me ,
i have tried puting these multiple date with multiple excel sheets with the same data but when uploading to power bi i can't create a relationship with all the Date tables tried Create a Date Table but still doesn't respond to the filters that i select , i also disable the Auto Time but cant get the data to react through the dashboardextracted from the excel 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.
5 Replies
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
Thank you for reaching out microsoft fabric community forum.May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi ssylvester
I wanted to check if you had the opportunity to review the information provided by Ritaf1983 . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi ssylvester
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
