Forum Discussion
Help with Formatting a Matrix with Multiple Hierarchical Levels in Power BI
Hello everyone, I am working on a Power BI report that uses a matrix with 10 hierarchical levels to display my financial data. My goal is to create a P&L (Profit and Loss) presentation where data at...
1. learn about "sorting a column by another column"
2. learn about ISINSCOPE and how to adjust your measure depending on where you are in the visual. (Also cosider HASONEVALUE if applicable)
3. Add the +/- decorations to the rows (sadly not available yet for columns) and teach your users how to expand, collapse, and drill down or up in a matrix via the header icons or right click.