Hierarchy Order in Matrix

[jim_cribb]

Hello, 

I am attempting to build a P&L report in PBI Desktop and am struggling to correctly order a hierarchy of Account Types/Categories that I need to report by.

It is essentially a five-tiered hierarchy, 

The trouble I'm having is that the matrix automatically orders the holds the highest level at the top, and you cannot reorder . 

Please see attached sample file with matrix. 

I really want to be able to reorder each level of the hierarchy, ending up with 'Net Income' (top, level one of hierarchy) at the bottom of the matrix. I've thought about somehow rolling up the hierarchy into a single field, but would not be sure how to approach this.

Test.pbix

Thanks in advance,

[v-chuncz-msft]

@jim_cribb,

It seems that you may just change the order of the fields in Rows.

[jim_cribb]

Hi @v-chuncz-msft

Unfortunately not, as this would mean that the higher levels of hierarchy would be repeated.

[Anonymous]

Anyone found solution for this one? I am having the same problem