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 lower levels aggregates correctly to higher levels. However, I am facing a sorting issue: for example, I find the "Profit Before Tax" appearing at the top, while I would like to reorganize it so that it fits properly within the structure of my P&L (exemple here) Here are a few specific points where I would appreciate your help: Custom Sorting: How can I define a specific sort order for my hierarchical levels so that they display in the desired order? Data Aggregation: Is there a method to ensure that values aggregate correctly at each hierarchical level? Matrix Formatting: What are the best practices for formatting a matrix with so many levels to ensure optimal readability? Thank you in advance for your help and suggestions. Any advice or resources would be greatly appreciated! Best regards,
Hierarchy in matrix visual: blank rows
Hi everyone! I have a hierarchical tree of departments and i would like the show the processes_id in each unit like that using the matrix visual. The strings in the format xxx-yyyy are the processes id that are in each unit. It's working amost well except the blanks rows 😞 I would like to know if there is way not showing the blank rows. The option 'Show items with no data' is unchecked. In 'rows' i put the four levels and the process_id. The pbix file is here! Thanks for any help!
