PowerBI - Report and loss format

[AlexXandyr]

Hello everyone,

Im trying to replicate an excel report that are using a kind of PnL layout (pic 1). Tried but get some weird layout in PBI and cant figure it out (Pic 2). Pic 3 is me trying to group our accounts correctly. So would I would like is for the Totals in Pic 2 to be replaced by for example Operating Income that comes now above instead of below Revenue and Cost of Sales. 

Any ideas? 

Pic 1

Pic 2

Pic 3

[Idrissshatila]

Hello @AlexXandyr ,

check these videos 
https://youtu.be/PI52ckgezzA?si=gkmkv-0TXmmCoUcC

https://youtu.be/J4317R5BvsA?si=Y2D5s1TFB26FAfak

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[AlexXandyr]

So no easy way of moving the row headers down below second level (called Narration in my case)? 

[Idrissshatila]

@AlexXandyr , unfortunatly no easy way, you should do it by the structure in the videos.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[AlexXandyr]

Ok, thank you @Idrissshatila