Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Build a P&L / income statement report in Power BI in less than 5 minutes

by Inforiver | Oct 28, 2021 | ,

Anyone who has attempted building financial statements, including a P&L statement report, or an income statement in Power BI using the native table or matrix visual knows how time-consuming the task can be. The complication comes from several reasons, including but not limited to (a) having to encode a custom sort order for accounts in the data model (b) using DAX to not only perform calculations but also to conditionally populate rows based on GL accounts/subtotals (c) formatting limitations (d) limitations in handling accounting signs (+/-), and more.

Let’s take a quick look at how Inforiver can deliver a financial statement in less than five minutes in Power BI, without using DAX.

Build a P&L / income statement report in Power BI in less than 5 minutes

Once you have mapped your accounts (categories) and values (measures) to Inforiver, you can perform extensive formatting changes to get the desired format that you want in your profit & loss / income statement reports.

  • Format and indent GL account headers
  • Add single-line and double-line borders above/below specific values & rows
  • Add a vertical analysis column to show everything as a % of Revenue in a single click
  • Bring in budget or prior period performance data and calculate variances
  • Group column headers, something that is often common in profit & loss statements
  • Insert calculated rows to show derivative KPIs such as Gross Margin % or Earnings Per Share (EPS)
  • Add a static record to capture values not often found in your financial database - such as number of shares outstanding. This can be further used EPS calculation as listed above.
  • Add footnotes & annotations for specific accounts
    … and more

Sample P&L / Income Statements in Power BI

Here are some sample formatted financial statement reports built in Power BI. Click on the images to explore the interactive demo.

Financial Reporting in Power BI using matrix/table - Nike
Financial Reporting in Power BI using matrix/table - AMD
Financial Reporting in Power BI using matrix/table - Amazon
Financial Reporting in Power BI using matrix/table - Chevron
Financial Reporting in Power BI using matrix/table - GE

To download these demo files (.pbix) in Power BI, visit our demo page here.

Related content (Part 2 of the video): Formatting P&L/Financial Statements in Power BI

Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
5920 Windhaven Pkwy, #130
Plano TX 75093
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram