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 - 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

Share this on:

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
About Inforiver!
Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 3,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram