Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to 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.
@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.
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
Thanks will look into that!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |