drill down in matrix not working with date

[Anonymous]

I have a date table.  

I have year, quarter and month as rows.    And I have total sales as values.    Nothing in column.  

When I try to drill down using my date table hierarchy, the double arrow (two side by side arrows) does not work....but the "trident" arrow does.    I can use it to drill down.   

If I use the double arrow , I get the contiguous dates error message.    

Any idea why? 

[v-henryk-mstf]

Hi @Anonymous ,

Can viewing this video help you?Drill Down and Drill Across data in a Matrix Power BI - YouTube

If the problem is still not solved, can you provide detailed test data and detailed requirements so that I can do further testing?

Best Regards,
Henry

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

[mpicca13]

I've acutally just encountered the same issue, I have no idea what the cause of this is, as i have multiple reports connected to the same model and the drill-throughing the matrix to the date grouping as the last value doesn't seem to work but if date is not last in the grouping it works. 

[nvprasad]

Hi,

Could you please try with Calander or Date table columns in the row section? 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[Anonymous]

Yes, all the date values in my rows are from the date table