Matrix Visual Grouping and SUbtotals

Hi @yendluru.aj,

Power BI is not the same as Excel, trying to replicate an ‘old’ but familiar Excel report can be challenging at times. So it can help to manage expectations, addressing the differences between the two tools early on. Non the less there are several techniques that combined will get you pretty close - I think.

For the Column Headers review this post.

And for the Grouping + All Other row dive into the Financial reporting section within the resources. There are many forum topics on this subject, you can use the Search option, to explore those…

If, after reviewing the content, you need further assistance please review the forum guides on what you can do to help other members get involved and help you work towards a solution. Thanks!

1 Like