cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
naeemakhtar110 Frequent Visitor
Frequent Visitor

Profit and Loss Report with Table Layout and Custom Groups

Hello,

 

I am looking to build a highly formatted profit and loss report and having couple of challenges to design a particular layout as per requirements.

 

  1. Below is screenshot of the layout. I beliee such is not possible through Pivot Table as account group dimention need to be in the middle and values to be on the right and left side on it. Please advise on how we can achieve this.
  2. There are 4 custom groups in the report which are calculated fields. How to show custom group and account group dimention in same column?

Regards

Naeem Khan

 

pl.PNG

 

 

 

 

1 REPLY 1
Highlighted
MaxNovak Regular Visitor
Regular Visitor

Re: Profit and Loss Report with Table Layout and Custom Groups

Hi,

 

Maybe this article can help you better make and format your P&L Report. 

 

Personally, I don't think that it is a good idea to put dimensions in the middle. 

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors