Forum Discussion
Power BI Matrix Last Node (in Rows) should display on all levels (of rows) as and when expanded
Hi Alpha0904 ,
Thanks for checking and for the clarification, as u said my previous example used columns mainly to demonstrate the value behavior but that is not required for your scenario, from what you described you want the last level Types to be visible across all levels in the row hierarchy when expanded, and this is more about how the matrix displays hierarchy than just measure logic because Power BI does not natively repeat leaf level values at higher levels, the PBIX I shared was focused on value behavior so it may not fully match your requirement, achieving this would need some additional modeling or DAX approach rather than just visual settings, if you can share a small sample of your hierarchy It would be helpful.
Hi rohit1991 , Thanks for sharing... each of my power bi matrix has about 60+ measures and each matrix has different set of combination of measures.. not sure if its still manageable your route ? can you share a sample pbix file on the lines of your proposal , since above is little difficult for me to follow along
Hi Alpha0904 ,
I was able to reproduce your scenario and have shared a sample PBIX for reference where the matrix is structured with Category and Product in rows and Subcategory in columns and the requirement of showing the last leaf level value at higher levels instead of aggregated totals is working as expected you will notice that at the Category level the values reflect the last product within each subcategory rather than a sum which should align with your requirement even in more complex setups so please have a look at the file.
This approach should still be manageable even with multiple measures and can be further optimized if needed.
Please find the below attached .pbix file.
Thank you.
Dear v-sshirivolu , Thanks for sharing however i looked at it and not sure how this will fulfill my reqruiement. I want The Types to be shown at all levels when they are opened up... i guess you are proposing to shift it to columns rather ?
Hi Alpha0904 ,
Thanks for checking and for the clarification, as u said my previous example used columns mainly to demonstrate the value behavior but that is not required for your scenario, from what you described you want the last level Types to be visible across all levels in the row hierarchy when expanded, and this is more about how the matrix displays hierarchy than just measure logic because Power BI does not natively repeat leaf level values at higher levels, the PBIX I shared was focused on value behavior so it may not fully match your requirement, achieving this would need some additional modeling or DAX approach rather than just visual settings, if you can share a small sample of your hierarchy It would be helpful.Hi Alpha0904 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.