Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

How can I create a P&L with figures to the left and to the right of categories


I am wondering if it is possible to get a P&L in Power BI with the following structure:

Figures ----- Categories ----- Figures

Please, see image above for better understanding!

Allow grouping rows of categories is also needed

Thanks in advance.






Community Support
Community Support

Hello, @JoseS  Any updates?


Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.


Best Regards,

Community Support Team _ Janey

No, all of them use same format with description on the left not in the middle.

Thanks anyway.

Community Support
Community Support

Hi, @JoseS 


I think it's okay, it's up to you how to do it.

You can check the tutorials:

Virtual Meetup: How to build a P&L with Power BI - YouTube

How To Create Profit And Loss (P&L) Statements In Power BI | Enterprise DNA


Best Regards

Janey Guo


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!