pivot table drill down

Hi, Gabry ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,powerbiexpert22.I am glad to help you. 

As Gabry mentioned, you can't implement the drill-down effect for dates in the matrix with your current data structure. Since the implementation of the drill-down effect requires the fields to have a hierarchy, you need to create a hierarchy for dates and enable the drill-down feature. At the same time you need to adjust the data formatting: make sure that your dates are formatted correctly so that the data is displayed correctly when switching between hierarchies. This may involve changes to the data, which you will need to double-check to make sure the model is correct.
Luckily, I found other issues similar to yours that have been resolved, and hopefully they will help you.
URL:
Solved: Matrix - show data from most recent month in Yearl... - Microsoft Fabric Community
Generate Year and Month Combinations in Power BI Report using DAX - RADACAD

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.