Hierarchy : Display children before parents (eg : for profit and loss presentation)

[Tiptip]

Hi all,

I'm mainly working with financials data (PnL) and I'm searching for a new BI tool in order to replace our old one and more particularly this feature : 

Do you if Power BI can display SSAS Tabular ragged hiearchies in a table or pivot table with childrens before parents (and not after parents) like this : 

     - Turnover

    -  Expenses

= Net Result

In the example, "Net result" is the parent of "Turnover" and "Expenses".

Then our user should be able to navigate in the hierarchy (drill down)

Most of the time, generic BI tools are only able to display the hierarchy like this (which is not the right display of a PnL) : 

 = Net Result

    - Turnover

    -  Expenses

Note : This is a simplified hiearchy, real one contain hundreds of members with several levels

thanks!

[gckcmc]

I know you explicitly asked for a bottoms-up vs. tops down, but this is how I traditionally see a PnL statement:

https://zebrabi.com/power-bi-custom-visuals/beautiful-income-statements-power-bi/

(there are a lot of visuals that are like this, this one is just an example)

not sure if this helps...

[Tiptip]

Yes that's it, I'm searching for a BI / reporting tool that can manage natively "bottoms-up" display of a hierarchy.

My users are always digging / drilling in the PnL hierarchy until accounts numbers and not only on aggregates so having a tool that can handle that natively will save us a lot of time.

[v-chuncz-msft · Accepted solution]

@Tiptip 

You may try Matrix visual and set Subtotals > Row subtotal position in the Format section of the Visualizations pane.