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

[ssylvester]

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

[snamalok]

@Ritaf1983

Really appreciate the assistance just finished the data from excel and it interacted through my dashboard in powerbi , really tough dublicating and appending it in excel to power bi but really made all date to interact with the informations

Regards 

Seth

[v-shamiliv]

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.

[v-shamiliv]

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.

[v-shamiliv]

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.

[Ritaf1983 · Accepted solution]

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.