Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

drill down in matrix not working with date

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? 

Need Help

4 Replies

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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

  • mpicca13's avatar
    mpicca13
    Icon for Resolver IV rankResolver IV
    5 years ago

    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. 


  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    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.