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.
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.
Here are some sample formatted financial statement reports built in Power BI. Click on the images to explore the interactive demo.
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