Forum Discussion

AlexXandyr's avatar
AlexXandyr
Icon for Helper I rankHelper I
3 years ago

PowerBI - Report and loss format

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

 

 

4 Replies