Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Drill down Matrix/Table

Hi,

 

I have created a matrix 'Profit and Loss' which reads the data from a SAGE database.  What I am being requested for is the ability to drill down from the figures in the 'P&L' to journal level (what makes the figures up).

 

This feature is in Excel I am just wondering if there is a way to do this in PowerBI.

 

Thanks

 

Chris

  • Anonymous

    You can use "Analyze in Excel" feature to create a report in Excel. 

     

    With PowerBI, there is a limited functionality with matrix visual and unfortunatly,drill down is currently not supported.

    However, microsoft has considered these feature request as priority and we will soon get the such functionality in near future. Check ideas section to know more.  

3 Replies

  • Anonymous

    You can use "Analyze in Excel" feature to create a report in Excel. 

     

    With PowerBI, there is a limited functionality with matrix visual and unfortunatly,drill down is currently not supported.

    However, microsoft has considered these feature request as priority and we will soon get the such functionality in near future. Check ideas section to know more.  

    • avanthi's avatar
      avanthi
      New Member

      Hi Power BI Team ,

       

      I am also looking for Drill down option in Matrix view, please let me know when this feature will be available

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks will look into that!