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

Finance Income Statement in Power BI --Paginated Reports?

HI ,

 

Was creating Income statement and P&L reports in Power BI but i am not able to achieve format Like below this is pretty common requirement for finance stakeholders

 

Is there any way to achieve it  ? did any one tried  working on this kind of requirement?

 

is it possible via paginated reports? if yes can any one share some links or  her/his experience ?

Any help would be highly appreciated

Varun511_1-1635195626109.jpeg

 

 

 

5 REPLIES 5
aj1973
Community Champion
Community Champion

Hi @Varun511 

I had a different approach, check out my report.

Microsoft Power BI

 

each row you see in the Matrix is a measure, this way when the user exports the Matrix all he has to do is pivot the table and will have his View as it was in Power bi.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

TheoC
Memorable Member
Memorable Member

Hi @Varun511 

 

Yes, it can be achieved. Just use a Matrix table. 

 

Places the Parent Accounts (i.e. Revenue / Expenditure, PBIT, etc) as Rows.  Underneath the Parent Accounts in the Rows field, place your Subaccounts.  Ideally, you should use your Chart of Accounts for establishing this.

 

If you have a single Column for values and a separate column for distinguishing Debits and Credits, then drag the Column that identifies Debits / Credits in the Columns field of the visual pane.  If you have two separate columns being one for Debits and the other for Credits, then drag both into the Value field (i.e. replace the Amount in the below screenshot with both the Debit and Credit columns).

 

TheoC_0-1635210206522.png

 

Using the formatting tools (the paint brush icon above Rows) to modify background colours / text colours, etc.

 

This will achieve what you're after as I have many client modles for P&L, Balance Sheets, Cash Flows, etc., etc.


Hope this helps 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

Varun511
Frequent Visitor

Can i do it same way in paginated reports any idea?

TheoC
Memorable Member
Memorable Member

@Varun511 if you've structured your paginated report in line with the P&L, BS, Cash Flow or any other such report, you should have no issues feeding in the relevant fields. However, I do recommend getting a sound understanding of paginated reports prior to going down this path if you haven't as yet.  Here is a starting point: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-aw

 

Hope it helps mate 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?  www.linkedin.com/in/theoconias

aj1973
Community Champion
Community Champion

@Varun511 

Paginated reports is mostly used to export tables that exceeds 150000 rows. In your case I don't think it will help you out

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.