Drill down Matrix/Table

[Anonymous]

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

[BhaveshPatel · Accepted solution]

@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]

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]

Thanks will look into that!